Changing cell colors based on values

  • Thread starter Thread starter Jon Willits
  • Start date Start date
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
 
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,

you can use the Conditional formatting option in excel.

Format > Conditional formatting.



Cesar Zapata
 
Yes, Jon,

Look at Format>Conditional Format

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top