| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add a row and totals based on changing cell values | Excel Worksheet Functions | |||
| Dynamically setting CELL COLORS based on TWO OTHER cell values | Excel Discussion (Misc queries) | |||
| Changing values in a row based on a cell in the row. | Excel Discussion (Misc queries) | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| Help Evaluating Cell Values and Changing Colors | Excel Programming | |||
Linear Mode
