Conditional Formatting

0

I need help with a formula for conditional formatting.  If A1 is NOT blank, then I want to highlight B1 and C1 until an entry is made in either B1 or C1.  This formula would then be applied to B1:C25.

Thank you

Answer
Discuss

Answers

0
Selected Answer

Select the range B1:C25 and apply "Use a formula to determine which cells to format" with the formula below (including the = sign).

=AND($A1<>"",$B1="",$C1="")
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login