Conditional Formatting - Highlighting Certain cells if one of them is blank
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!
|