Sunday, May 04, 2008 – Permalink –
If it's Tuesday, it must be mauve
This can be very useful for highlighting important information and values outside an accepted range or providing a visual cue to associate value ranges with color codes.
Just click the cells you'd like to format and select Format >Conditional Formatting. The Conditional Formatting dialog box lets you set up the conditions by which the formatting of the cell will occur.
You pick the operator (between, equal to, less than, etc.) and the value or range of values. Click Format to open the Format Cells dialog box, where you can select the colors and styles to be used.
However, you can format that same cell to exhibit red, bolded text on a green background if it contains a value between 51 and 100.
GR Business Process Solutions:
<Doug Klippert@ 7:03 AM
Comments: Post a Comment