Excel formula to change cell color based on due date 285348-How to change excel cell color based on date
4 When the New Formatting Rule window appears, select the "Format only cells that contain" rule type Then select Cell Value in the first drop down, less than in the second drop down, and enter the following formula =NOW()30 Next, we need to select what formatting to apply when this condition is met To do this, click on the Format To change the color of the weekends, open the menu Conditional Formatting > New Rule In the next dialog box, select the menu Use a formula to determine which cell to format In the text box Format values where this formula is true, enter the following WEEKDAY formula to determine whether the cell is a Saturday (6) or Sunday (7) =WEEKDAY (B$5,2)>5What this formula means is that the date in the cell is past today's date To select what formatting to apply when this condition is met To do this, click on the Format button When the Format Cells window appears, select the Fill tab Then select the color that you'd like to see the expired dates ...