Mar 31 2022 06:51 AM
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?
Mar 31 2022 07:08 AM
SolutionChange 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")
Mar 31 2022 07:12 AM
Mar 31 2022 07:08 AM
SolutionChange 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")