In the attached, conditional formatting has been applied to D2:D15. It doesn't matter whether the cells in column D contain text, numbers or a formula.
Bear in mind that conditional formatting makes the cell appear blank; it still contains the data that was there when the value in column E is not 1.


The CF formula is
=$E2=1
it's applied to D2:D15
the conditional formatting applied is:
;;;

Attached Files

msofficeforums51100.xlsx (9.2 KB, 5 views)