Forum Discussion
Excel - conditional formatting help
Hi Please help, I have created a spreadsheet and have formulas when a date is enter it projects 30 day and 90 days into their respective columns. I would like to conditional format these columns to ...
salway42 Difficult to be sure without seeing your file, but a CF rule highlighting cells where the value is less than TODAY( )+5 should give you the desired outcome. It marks all passed dates and the ones for the coming 5 days.
(Picture taken on a Mac, but similar on PC)
Thank you, I have snipped a copy of my spreadsheet to provide further context.
Are you saying I can use the "=today()" formula even though the dates do not have anything to do with today, but the actual date in the column?