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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Conditional Formatting
0
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="")