Colouring a cell automatically

Closed
Bang - Jul 15, 2009 at 02:47 AM
Bang....... Posts 1 Registration date Tuesday July 14, 2009 Status Member Last seen July 15, 2009 - Jul 15, 2009 at 08:57 AM
Hello Guys,

I don have much knowledge abt Excel and abt the codes n stuff.... But i have a question to ask u guys...

The question is this:

There is a blank cell. When I enter some value in that cell the cell should turn to a particular colour say RED.
If I delete that value again the cell should become white as usual.... Is this possible??

I tried to understand what suggestions u people had given above but nothing went to my head. This question may be silly but I'm not able to figure it out. Can some of you help me out?

Regards,
Bang

2 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 15, 2009 at 07:34 AM
regarding my instruction remember my excel version is excel 2002. I am sure this will apply to 2003 .


in 2007
Home-style-conditional formatting-new rules-
under "select a rule type"
click
"format cells only cells that contain"
click arrow next to "cells value is"
in downloaded window choose "non blanks"
click format (second line right)
choose "fill"-the last item
choose main color from the last row
click ok
again click ok
1
Bang....... Posts 1 Registration date Tuesday July 14, 2009 Status Member Last seen July 15, 2009
Jul 15, 2009 at 08:57 AM
Hey Venkat.... thnx a lot dude!!! it works.... wonderful... u r a genius!

I liked the way u explained it....

Thnx a lot again.
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jul 15, 2009 at 07:22 AM
you try this . read this carefully

suppose the relevant cell si A1

highlight A1
click format(menu)-conditionalformat
in the conditionalformat window just below "conditon 1"
click the small arrow
choose "the formula is"
in the next small window to the right type this
=NOT(ISBLANK($A$1))
(change A1 to any other cell if you want)
click format in the middle right
in the resulting window choose "pattern"-the third and last one
in the color palette choose the color (click the color)
click ok
again click ok

now fill A1 with some entry see what happens .
delete that entry see what happens.
post feedback
0