Forum Discussion
Conditional Formatting Days since Date
Hi Hans,
Column F contains the drop off date, column J contains the function =F27+10. I need to format column J, which I can do, but the challenge I have is that I need to format it so I have different colors for different days added to the drop off date all in the same cell
Yellow for +10
Orange for +12
Orange for +14
That is why I asked if you can have more than one formula in a single cell e.g. =F27+10, =F27+12 and =F27+14 and then color code them accordingly. Because my logic say that I would need 3 different columns for each days added. In practice I need the following, if 10days has passed from drop off date then the cell must change color to yellow, 12 days has passed change to orange and after 14 days after drop of it must turn red.
I hope this makes more sense
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.
Hans, I applied the formula but die column don't change color. The only other formula in the column is =F27+10.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Thank you!