Conditional Fomating Question
Hi, I'm stuck on figuring out some conditional formatting.
I have two date columns "Due On" and "Completed On" and would like to turn the Due On cell green if the Completed On date is before the Due On date. On the same coin, then I want to turn the Due On cell red if Completed On date is after the Due On date. I've figured out how to turn them colors if overdue and NOT completed but not once it is completed.
Comments
-
Samantha, probably the easiest way to make a cell one of two colors is to format the cell color green, for example, and then turn it red with conditional formatting if the condition is true. I may not completely understanding what you're trying to do so you may have to have more than one conditional formatting rule for the same column and the first rule that has the condition true will take precedence.
Jim
-
Hi there, you can add multiple conditions to a Conditional Formatting rule. Like you could put, if the due date is in the past, and the status contains specific words... To add an additional rule, click on the little arrow to the left of the rule. See my screenshot below.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives