Conditional Formatting Behaving Unexpectedly
Hi,
I have not been able to figure out what to change to get the conditional formatting in the sheet, per the second rule, to dynamically change as time passes and/or the status changes. The red font is not changing back to black when the End Date becomes in the past, and/or the status column is changed to Complete. Thanks in advance for your help.
Best Answer
-
Hi @Land606,
Though they appear black, do the values in the 1st & 3rd rules have the font colour set to automatic (probably by default)? If so, the font won't change colour. If you actually pick the black colour then they should change.
Answers
-
Hi @Land606,
Though they appear black, do the values in the 1st & 3rd rules have the font colour set to automatic (probably by default)? If so, the font won't change colour. If you actually pick the black colour then they should change.
-
Genius! That did the trick. Thanks very much for the quick and accurate response :-)
-
No problem, glad to have fixed the issue for you. 🙂
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives