Changing cell colors based on values

J

Jon Willits

Is there a way to automatically change cell colors based on cell
values? For instances, if I am keeping track of running averages in
one row, can I have it set up to automatically make the cells that
exceed a critical value always be red?

Thanks in advance.
Jon Willits
 
A

A.W.J. Ales

Jon,

Have a look at conditional formatting.
Format / Conditional Formatting / fill in the condition and the formatting.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
C

Cesar Zapata

Jon,

you can use the Conditional formatting option in excel.

Format > Conditional formatting.



Cesar Zapata
 
N

Niek Otten

Yes, Jon,

Look at Format>Conditional Format

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top