Conditional formating and date equations

Question

I'm using Excel for web.&nbsp;I have a column F, where we enter a date that task F is completed.&nbsp;Column G is an equation that autofills a date for a follow-up task:&nbsp; =IF(F95, F95+14)&nbsp;Column I has the same equation, but is based on the date for column G, which can be updated manually to the actual date that the task G was completed.&nbsp; =IF(G95, G95+14)&nbsp;The dates all work fine.&nbsp; I want Conditional Formatting to turn the date's text red for columns G or I when the date has come.&nbsp; The CF statement is:&nbsp; Cell Value &lt;= "TODAY()"&nbsp;The cells in F, G, and I are formatted to dates.&nbsp; Yet everywhere there is a date filled in (unfilled dates show up as FALSE), the text turns red, even if the date hasn't come yet.&nbsp; Is this possible to correct?&nbsp; Thank you for your help.&nbsp; All my Excel training is very old.

hansvogelaar · Answer

BHofKS&nbsp;
I used the exact conditional formatting rule mentioned by you.

hansvogelaar · Answer

BHofKS&nbsp;
It should work:

Could you attach a small sample workbook that demonstrates the problem? If you cannot attach to a reply, you can make it available through OneDrive, Google Drive, Dropbox or similar.

bhofks · Answer

Thanks for your reply. It's not something I can post online at all. I'm assuming you used the same info in yours with no problem. It might be a web problem.

Forum Discussion

Conditional formating and date equations

3 Replies

Resources