Conditional formatting : amount of decimals

[belgian11]

Conditional formatting should be extended for the amount of decimals. One
should be able to set the conditional formatting before entering the numbers
so the number entered in a cell is immediately rounded to the set amount of
decimals.
Example :
If a number is lower than 1 use 2 decimals
If a number is between 1 and 10 use 1 decimal
If a number is greater than 10 use no decimal

If 0.1234 is entered, Excel changes it in 0.12
If 1.234 is entered, Excel changes it in 1.2
If 12.34 is entered, Excel changes it in 12

The changes occur immediately after entering the number.

This should be made possible with conditional formatting so no macro's or
something else should be used. If one uses a file every day to enter numbers
that could range from 0 to 10000 it is time consuming to eacht time use the
normal formatting for setting the right amount of decimals.

Conditional formatting can now be used for colors, edges (tab 2+3+4 in cell
properties) but not for the others formats (tab 1+2 in cell properties).

I hope Microsoft will change this in a new version.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

[jmcguire1]

1. Select the range A1:A10.

Conditional Formatting Example

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click Highlight Cells Rules, Greater Than.

Highlight Cells Rules

4. Enter the value 80 and select a formatting style.

Greater Than

5. Click OK.

Result. Excel highlights the cells that are greater than 80.

Greater Than Result

6. Change the value of cell A1 to 81.

Result. Excel changes the format of cell A1 automatically.

Conditional Formatting in Excel

Note: you can also highlight cells that are less than a value, between a low and high value, etc.

Clear Rules
To clear a conditional formatting rule, execute the following steps.

1. Select the range A1:A10.

Select Cells

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click Clear Rules, Clear Rules from Selected Cells.

Clear Rules

Top/Bottom Rules
To highlight cells that are above the average of the cells, execute the following steps.

1. Select the range A1:A10.

Top/Bottom Rules Example

2. On the Home tab, in the Styles group, click Conditional Formatting.

Click Conditional Formatting

3. Click Top/Bottom Rules, Above Average.

Top/Bottom Rules

4. Select a formatting style.

Above Average

5. Click OK.

Result. Excel calculates the average (42.5) and formats the cells that are above this average.

Above Average Result