View Single Post
  #1   Report Post  
Wcngu1 Wcngu1 is offline
Junior Member
 
Posts: 4
Default 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!