Conditional Formatting
I've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions.
As an example: I want to show the date cell to show green if it is a future date with a Green Background UNLESS it is within 90 Days of Today's date. If that is the case, I want to show the background as Yellow.
Any suggestions?
Best Answer
-
You should be able to specify it being in the next 90 days within the conditional formatting rule.
Answers
-
You should be able to specify it being in the next 90 days within the conditional formatting rule.
-
Your suggestion worked, thanks.
But I failed to mention that I also want to format the cell if it is blank.
I've tried the "is blank" criteria selection, but it doesn't seem to do anything, the cell is left unformatted.
The formula in the column that I am trying to format is:
=IF(ISBLANK([Automatic Descent]@row), "", DATE(YEAR([Automatic Descent]@row) + 1, MONTH([Automatic Descent]@row), DAY([Automatic Descent]@row)))
I'm wondering if the "" portion of my formula is not read as "is blank" and that is why it is not formatting?
Bert
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!