1

I need your help with conditional formatting in Gsheet or Excel (I will choose one of them depending on the solution).

This format needs to be: Any empty cell in columns C to L must be highlighted if the respective cells in B are not empty.

It needs to look like this: enter image description here

Thanks in advance for your help!

1 Answer 1

2

The solution is to apply conditional formatting to the C2:L range with the custom formula:

=and($B2<>"",C2:L2="")

cond

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.