Changing cell color by value
 

Hi

Is it possible to make a range of cells red by default and then turn
green when certain conditions are met?

How is this done?

J;-)

Changing cell color by value
 

formatconditional formatting

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jgaard" wrote in message
...
Hi

Is it possible to make a range of cells red by default and then turn
green when certain conditions are met?

How is this done?

J;-)

Changing cell color by value
 

See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"jgaard" wrote in message
...
Hi

Is it possible to make a range of cells red by default and then turn
green when certain conditions are met?

How is this done?

J;-)