Auto Shading Cells
 

How do you Auto shade cells based upon the data found in the cell.

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.

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.

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.