Alerts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know a formula which will change a colour of its cell when a particular value is entered

e.g if "1" is typed in the cell.. the cell colour changes to red, when "2" is typed, it chages to blue... and so on...

Thanx Vinit
 
Vinit said:
Does anyone know a formula which will change a colour of its cell when a particular value is entered.

e.g if "1" is typed in the cell.. the cell colour changes to red, when "2"
Click to expand...
is typed, it chages to blue... and so on...
Thanx Vinit
Click to expand...

Take a look at Conditional Formatting (on the Format menu). Details are in
Help. You can get up to 3 different formats (in addition to the default).
 
If you just have 3 colors or 3 colors + the default color you can
use conditional formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you have more than the 3 colors provided via Conditional Formatting
you might use an Event macro if the numbers are manually changed
(not formulas)
http://www.mvps.org/dmcritchie/excel/event.htm#case

Otherwise you might just use a regular macro and run it as needed.

If you don't like those options then there may be others, but since
we don't know exactly what you have or how you get it we can't tell
you much more without further input.
 
Back
Top