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