Conditional Formatting - Highlighting Certain cells if one of them is blank

Giganews Newsgroups
Subject: Conditional Formatting - Highlighting Certain cells if one of them is blank
Posted by:  Wcngu1 (DreamerREMOVETHIS_WI…@HOTMAIL.COM)
Date: Wed, 4 Dec 2013

Hi guys,

I"m making a simple data entry form that requires 14 boxes to be filled
out.  I'm trying to make it so that when the 14 boxes are all filled in,
all 14 cells will turn green to symbolize that all boxes have been
filled in.

I have tried to google solutions but all I can find is for the entire
row to be highlighted if one is blank but that doesnt work for me since
I have hidden columns inbetween which i think messes things up..

I hope that made senese!

--
Wcngu1

Replies