Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Number Formats
I would like to change the number of decimals shown for
each number in a row of 50 columns based upon its value. For example, if the number is 100 then no decimals; if between 100 and 10 then 1 decimal place; and if <10 then 2 decimal places. I thought I could use conditional formatting, but it appears that technique only allows one to change fonts and backgrounds, not the formats of the numbers themselves. Is there any work-around or other tool I can try? Thanks in advance. |
#2
|
|||
|
|||
You could try the conditional formatting addin at
http://xldynamic.com/source/xld.CFPlus.Download.html which allows greater style of formats as well as more than 3 conditions. -- HTH RP (remove nothere from the email address if mailing direct) "AMcCormick" wrote in message ... I would like to change the number of decimals shown for each number in a row of 50 columns based upon its value. For example, if the number is 100 then no decimals; if between 100 and 10 then 1 decimal place; and if <10 then 2 decimal places. I thought I could use conditional formatting, but it appears that technique only allows one to change fonts and backgrounds, not the formats of the numbers themselves. Is there any work-around or other tool I can try? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
How do I set more than 3 conditional formats in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Conditional Formats in Excel | Excel Worksheet Functions |