Forum Discussion
Solved
Conditional Formatting Not Working
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 exclud...
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?
instead you want it in column G? is that what you want?