Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

After date conditional formatting.

I am using numbers. I have a cell B1 with a date, Cell B4 is a formula (B1-80) to calculate 6/20/14. I want to apply conditional formatting to say if 6/20/2014 is after todays date then make the cell red. I am using version 3.2. I can't figure it out even though it seems the obvious choice is Date>after>highlight B4 and done turns red since its 7/8. However its not working.😕

Posted on Jul 8, 2014 2:44 PM

Reply
1 reply

After date conditional formatting.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.