PDA

View Full Version : [SOLVED] Conditional formating if the cell is empty.



Jagdev
02-19-2015, 04:48 AM
Hi Experts
I am looking for a conditional formatting formula for the below criteria.
Say if there is a value in column A cell A1, then if any cell say B1, C1 and D1 contains empty cell, it should change the color of that empty cell.
Regards,
JD

p45cal
02-19-2015, 05:12 AM
Select say B2:D1000 (change the 1000 to your range)
The active cell should be B2, this is important.
Then while the above range is selected: Home tab, conditional formatting, New Rule…, Use a Formula to determine which cells to format then copy this formula:
=AND(NOT(ISBLANK($A2)),ISBLANK(B2))
Choose your format, click OK.

Jagdev
02-19-2015, 09:59 PM
Hi p75cal

Thanks for the code.. I find another one which fits into the requirement as well \

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

Regards,
JD