LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting / blank cells torkattack Excel Discussion (Misc queries) 6 January 28th 10 10:03 PM
Conditional Formatting Not Blank Cells Nate Excel Discussion (Misc queries) 6 February 22nd 08 10:25 PM
using conditional formatting - blank cells SD Excel Discussion (Misc queries) 5 May 9th 06 03:22 PM
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. Jamie Furlong Excel Discussion (Misc queries) 6 August 28th 05 09:27 PM
Conditional formatting blank cells kalz Excel Discussion (Misc queries) 2 August 12th 05 03:57 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"