Forum Discussion
Conditional Formatting Days since Date
I have a client spreadsheet and I am trying conditionally format the cells to highlight in color based on the number of days that have passed since the "Drop off" (Column F) in the same cell/column (...
Thank you. Let's say you want to apply this to J27:J100.
Select this range. J27 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
=J27>=F27+10
Click Format...
Activate the Fill tab.
Select yellow as fill color.
Click OK, then click OK again.
Repeat these steps, but with the formula
=J27>=F27+12
and orange as fill color.
Finally, repeat with
=J27>=F27+14
and red as fill color.
Thank you!