Forum Discussion
Conditional Formartting
So i have a cell that i'm putting the date of when someone last completed an exam that has to be done every 30 days. It already has one rule to be shaded red if the cell is blank. Now i want tye date ...
Hi Garret,
Try out the attached
I think you just need to switch around your formula
=Today()-$I2<=29 is blue for example