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
Bang....... Posts 1 Registration date Tuesday July 14, 2009 Status Member Last seen July 15, 2009 - Jul 15, 2009 at 08:57 AM
Related:
- Colouring a cell automatically
- Download automatically while roaming - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Pc restarts automatically - Guide
- How to open a web page automatically in full screen mode in html - Guide
- How to automatically save photos from messenger to gallery - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 15, 2009 at 07:34 AM
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 15, 2009 at 07:22 AM
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
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
Jul 15, 2009 at 08:57 AM
I liked the way u explained it....
Thnx a lot again.