| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Shading Cells
How do you Auto shade cells based upon the data found in the cell.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Shading Cells
Use FormatConditional Formatting and then either the pre-set criteria or a
formula you specify. "Viper51546" wrote: How do you Auto shade cells based upon the data found in the cell. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Shading Cells
Click FORMAT in the menu and select CONDITIONAL FORMATTING. State your
criteria and select the fomatting you wish to use. When the condition is met by the cell value the format specified is applied. -- Kevin Backmann "Viper51546" wrote: How do you Auto shade cells based upon the data found in the cell. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Shading Cells
Thanks! That is exactly what I needed! Appreciate your help!
"RayportingMonkey" wrote: Use FormatConditional Formatting and then either the pre-set criteria or a formula you specify. "Viper51546" wrote: How do you Auto shade cells based upon the data found in the cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-format shading color. | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Auto color-shading of rows | Excel Worksheet Functions | |||
| Auto color-shading of rows | Charts and Charting in Excel | |||
| Auto shading | Excel Worksheet Functions | |||
Linear Mode
