Conditional Formatting

shina67

Board Regular
Hi, I have cell's A though to L. I am wanting the cells filled red unless all the cells have either a value or text in them. All the cells would then change to green. If 1 cell is blank then all cells are red. If all cells have something in them then they all turn green.
Thanks in advance
 

Joe4

MrExcel MVP, Junior Admin
Use the COUNTBLANK function in your CF formulas, i.e.
Code:
=COUNTBLANK($A1:$L1)=0
for green
and
Code:
=COUNTBLANK($A1:$L1)>0
for red.
 

Some videos you may like

This Week's Hot Topics

Top