Changing cell colors based on values
 

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

Changing cell colors based on values
 

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 *

"Jon Willits" wrote in message
om...
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

Changing cell colors based on values
 

Jon,

you can use the Conditional formatting option in excel.

Format Conditional formatting.



Cesar Zapata

Jon Willits wrote:

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

Changing cell colors based on values
 

Yes, Jon,

Look at FormatConditional Format

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jon Willits" wrote in message
om...
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