Changing the color of a cell

[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

 

[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

 

[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

.

 

[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