Monday, August 14, 2006

Conditional Formatting in Excell

Just for information did you know that it is possible to color a cell in excel while it is blank and suddenly after putting the value the color will be removed Try this:

 

Format >>>> Conditional Formatting >>>>> Cell Value >Equal > to >0 and then  >>>> press format , and you can put whatever color you want..

 

Hope this Help

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails
tracker