Changing cell color by value

[jgaard]

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;-)

 

[Don Guillett]

format>conditional formatting>>>

 

[Bob Phillips]

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

--
HTH

Bob

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