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")
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")