If a2 is not empty, color empty cells in b2:af2

[turkanet]

Dear All,
Would you ple help me for below formula request?

if A2 is not empty, then make empty cells RED COLOR in B2:AF2, and apply this rule to A2:AF5000

 

[etaf]

for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting


Highlight applicable range >>

B2:af5000



Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:



=and($A2<>"",B2="")



Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[turkanet]

thx etaf, this worked fine.

 

[Macropod]

Cross-posted at:
If a2 is not empty, color empty cells in b2:af2
If a2 is not empty, color empty cells in b2:af2
If a2 is not empty, color empty cells in b2:af2

Please read Mr Excel's policy on Cross-Posting in rule 13: Forum Rules

Note: This is the second thread where you have ignored the cross-posting rules on this and other sites. Kindly read and comply with the rules of ALL forums you subscribe to.