Colouring a cell automatically

Closed
Report
-
Posts
1
Registration date
Tuesday July 14, 2009
Status
Member
Last seen
July 15, 2009
-
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

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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
Posts
1
Registration date
Tuesday July 14, 2009
Status
Member
Last seen
July 15, 2009

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
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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