How do you Auto shade cells based upon the data found in the cell.
R RayportingMonkey Sep 7, 2007 #2 Use Format>Conditional Formatting and then either the pre-set criteria or a formula you specify.
K Kevin B Sep 7, 2007 #3 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.
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.
