Hot answers tagged conditional-formatting
Rather than using Specific Text, try using Cell Value and equal to, then enter C for one rule and O for the other (do not enter equal or quotes when entering the letter, Excel does it for you). This will look for the only the letters that match. Applied to the whole column, this ignores text of the Open / Closed heading.
Only top voted, non community-wiki answers of a minimum length are eligible