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

[Guest]

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

 

[Guest]

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)

 

[Guest]

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/com...3599f9-219e-4ee7-a340-1fc2bc9b9776&sloc=en-us