View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default CONDITIONAL FORMATING!!!!!

I hava a worksheet that a fill up completely but sometimes I do not have all
the require information and I need to go back to it. What I need is a
conditional formating to color the whole sheet but when I write anything
including numbers or text or dates the color disapear, that way I'll find
easy to find the part that I did not fill up ( for ex. it will be blue). The
worksheet is from A1 to G1 across and from A1 to A45 down. Tx