Search : in
By :

Colouring a cell automatically

Last answer on Jul 15, 2009 1:57:07 pm BST Bang, on Jul 15, 2009 7:47:34 am BST 
 Report this message to moderators

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

Configuration: Windows Vista
Safari 530.5

Best answers for « Colouring a cell automatically » in :
Colouring cells on conditions Show Colouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Text String count within a Cell (Solved) Show
Background color of cell in Excel Show
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Automatically Launch a program at PC startup ShowAutomatically Launch a program at PC startup The problem Solutions Not touching the registry By modifying the registry Disable its launch The problem Some programs such as Mozilla Firefox, Internet Explorer or the e-mail programs...
Download Caledos Automatic Wallpaper Changer ShowCaledos Automatic Wallpaper Changer, as its name indicates, is a screen background administrator. The main features of Caledos : - it supports the image formats BMP, GIF, JPG, TIF, - easy selection of files or folders, - the possibility of...
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Dont panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
Download Automatic Backup ShowWhen you lose your data, it is not necessary to persuade your that to possess an effective saving program is the best solution. Automatic Backup is a program which will not only protect your data, but it will also keep the former versions of your...
Backgrounds ShowAdding a Background Image A background image for a web page can be set using the tag: Attribute Visual Effect BACKGROUND="image" Displays image as background bgcolor="name_of_Colour or #XXXXXX" Displays the given colour...
Introduction to Office Automation ShowWhat is office automation? The term office automation refers to all tools and methods that are applied to office activities which make it possible to process written, visual, and sound data in a computer-aided manner. Office automation is intended...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

venkat1926, on Jul 15, 2009 12:22:22 pm BST

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

   
Reply to venkat1926

2

venkat1926, on Jul 15, 2009 12:34:39 pm BST
  • +1

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

   
Reply to venkat1926

3

 Bang......., on Jul 15, 2009 1:57:07 pm BST

Hey Venkat.... thnx a lot dude!!! it works.... wonderful... u r a genius!

I liked the way u explained it....

Thnx a lot again.

   
Reply to Bang.......
Ask your question Reply
They need your help