I am looking for a formula to insert into a conditional format that will fill cell with red if date = >TODAY()+90 and if the cell does not contain text. This is a group used worksheet and when an item is complete, most people place the text "closed" within the cell that contains the date. I have already formatted those cells but now need to ignore them and format only those that are more than 90 days away. Thanks for the help and go easy on me, I'm fairly new to excel and this is my first thread!
Bookmarks