Conditional formatting if another cell is empty
Solved
Florent
-
Florent -
Florent -
Good evening everyone,
I have a little issue with Excel, I’m trying to set up a conditional formatting rule with the following condition:
If A1 is empty, then B1 should turn red.
But I'm having trouble setting this up, I know how to apply conditional formatting for cells that contain something.
Thank you in advance for your help
Configuration: Windows / Chrome 31.0.1650.63
I have a little issue with Excel, I’m trying to set up a conditional formatting rule with the following condition:
If A1 is empty, then B1 should turn red.
But I'm having trouble setting this up, I know how to apply conditional formatting for cells that contain something.
Thank you in advance for your help
Configuration: Windows / Chrome 31.0.1650.63
1 answer
Hello,
I responded to a similar request I hope it's not a duplicate request
the formula of your conditional formatting is
=AND(A1<>"";B1="")
or simply
=A1=""
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
I responded to a similar request I hope it's not a duplicate request
the formula of your conditional formatting is
=AND(A1<>"";B1="")
or simply
=A1=""
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Thank you very much!