Conditional formatting : amount of decimals

B

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/com...f-8424b3464b66&dg=microsoft.public.excel.misc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top