Changing the color of a cell

N

Nigel

Is there any way to program it so a cell changes color
based on the value in the cell,

ie the value is <10 the cell is blue
the value <20 its red

etc

thanks
 
M

mzehr

Hi Nigel,
Try using Format/Conditional Formatting/
you can then input your conditions and the color you want
the cell to change to based on the user input. Copy the
formatting down throughout the entire range you want
impacted.

HTH
 
N

Nigel

Perfect Thanks

Nigel
-----Original Message-----
Hi Nigel,
Try using Format/Conditional Formatting/
you can then input your conditions and the color you want
the cell to change to based on the user input. Copy the
formatting down throughout the entire range you want
impacted.

HTH

.
Click to expand...
 
B

BrianB

In the absence of another reply :-

Format/Custom allows 3 format options, otherwise you will need a macr
in the Change event of the sheet. There are lots of examples around.

Private Sub Worksheet_Change(ByVal Target As Excel.Range
 
Top