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 excluded from the conditional formatting, i.e. the date in column I remains unfilled with colour. Is anyone able to advise please?
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")
2 Replies
- you dont want color to filled in column I? ryt?
instead you want it in column G? is that what you want? 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")
