SOLVED

Conditional Formatting Not Working

Copper Contributor

Hi all

 

I've set up up some RAG conditional formatting, which seems to work fine. However, I now want to change it, so that where column G reads "Filled" or "Archived / Not Required", it is excluded from the conditional formatting, i.e. the date in column I remains unfilled with colour.  Is anyone able to advise please?

 

LL19911695_0-1648734570901.png

 

2 Replies
best response confirmed by LL19911695 (Copper Contributor)
Solution

@LL19911695 

Change the top two rules from 'Cell Value' + 'contains' to a single rule of type 'Use a formula to determine which cells to format' with formula

 

=OR($G8="Filled",$G8="Archived / Not Required")

you dont want color to filled in column I? ryt?
instead you want it in column G? is that what you want?
1 best response

Accepted Solutions
best response confirmed by LL19911695 (Copper Contributor)
Solution

@LL19911695 

Change the top two rules from 'Cell Value' + 'contains' to a single rule of type 'Use a formula to determine which cells to format' with formula

 

=OR($G8="Filled",$G8="Archived / Not Required")

View solution in original post