How do I set up a cell colouring formula in Excell 2003?
 

Hi,

I'm trying to set a formula so that if a cell value is less than a number
e.g 50 it turns the cell green and then if the value is 51 or more it turns
the cell green. Is this possible,

Thanks

Chris

How do I set up a cell colouring formula in Excell 2003?
 

have a look at conditional formatting under the format menu.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Fonzy" wrote:

Hi,

I'm trying to set a formula so that if a cell value is less than a number
e.g 50 it turns the cell green and then if the value is 51 or more it turns
the cell green. Is this possible,

Thanks

Chris

How do I set up a cell colouring formula in Excell 2003?
 

You may get a better idea from the response from T.Valko in this discussion
just a few posts below your original.
http://www.microsoft.com/office/comm...776&sloc=en-us

"Fonzy" wrote:

Hi,

I'm trying to set a formula so that if a cell value is less than a number
e.g 50 it turns the cell green and then if the value is 51 or more it turns
the cell green. Is this possible,

Thanks

Chris