Conditional Formatting Not Working

New 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?




2 Replies
best response confirmed by LL19911695 (New Contributor)


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?