Conditional formatting when cell is empty and another is not

[USAMax]

I need to highlight cells that must be filled in. It is easy to do when you are only looking at the ActiveCell but I need several cell to be highlighted if they are blank and the main Category has been filled in.

Example:
A1 = Main Category
B1 to E1 are sub categories.

If there is nothing in A1 then all the cells should be xlNone or white.
If A1 has been filled in then these cells must be highlighted if they are blank.

I do not want to do this through VBA.

Thank you,

 

[JoeMo]

Select B1:E1 then Conditional Formatting>New Rule>Use Formula

Formula is: =AND(NOT(ISBLANK($A1)),ISBLANK(B1))
set the format and click OK

 

[USAMax]

Thank you JoeMo, you sure have your mojo working today!

I was what you were doing and I was able to take it the rest of the way thanks to you.

=AND(NOT(ISBLANK(RC" & Target.Column & ")),ISBLANK(RC))

I thought I tried IsBlank but I spent too much time with IsEmpty!

Thank you for bring it home for me!

 

[JoeMo]

Thank you JoeMo, you sure have your mojo working today!

I was what you were doing and I was able to take it the rest of the way thanks to you.

=AND(NOT(ISBLANK(RC" & Target.Column & ")),ISBLANK(RC))

I thought I tried IsBlank but I spent too much time with IsEmpty!

Thank you for bring it home for me!

You are welcome - thanks for the reply.