My first instalment on conditional formatting broached the standard, by-the-book protocol for applying conditions to cells: selecting the cells you want to subject to the potential formats, and then ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results