Forum Discussion
Conditional formatting based on time elapsed from date
Hi there! I'm trying to figure out how to make a specific cell in a column appear a certain color based on the amount of time that has elapsed from a date in the cell in the adjacent column... If...
Select G4:H100 or as far down as needed. G4 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=$G4<=TODAY()
Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.
Repeat, but with
=$G4<=TODAY()-31
and yellow as fill color.
Then repeat again with
=$G4<=TODAY()-61
and orange.
Then with
=$G4<=TODAY()-91
and red.
Finally, with
=$G4<=TODAY()-121
and black.