Conditional Formatting

[shina67]

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]

Use the COUNTBLANK function in your CF formulas, i.e.

=COUNTBLANK($A1:$L1)=0

for green
and

=COUNTBLANK($A1:$L1)>0

for red.