Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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.😕
Hi Ken,
B1 Contains the formula =TODAY
Conditional highlighting of other cells in B if greater than $B$1 (using numbers, not dates)
Regards,
Ian.
After date conditional formatting.
