Select B1:C1, then apply CF using formula is: =$D1="N"
Format to suit, ok out
--
Max
Singapore
---
"Pass-the-Reality" wrote:
I need a conditional format formula that says if D1 = "N" than cells B1&C1
should be gray. What should I type in the conditional format statement?