Conditional Formatting Question

[mkfurlong483]

Hi Everyone, I know basic excel but I am having trouble. I have a spreadsheet and I want to highlight rows automatically after a 30, 60, and 90 day period (these are on separate tabs). The problem that I am having is the date is a time stamp. If I manually enter a date I can get it to work just fine but with the time stamp formula in the cell it doesn't work at all.

Thanks for any help!

 

[Special-K99]

Try

INT(A1) where A1 is the date and time, this will remove the time value