![]() |
|
#11
|
|||
|
|||
|
Well, I never was able to get the conditional formatting to work properly, but I was able to solve my problem by updating the formula for the fields that I needed formatted. The following calculation does what I want:
IF([value]<10, TEXT(ROUND([value],2),"0.0#"), CONCATENATE(ROUND([value],2)) ) (the CONCATENATE part may not be needed, but in the larger formula that I was working with which combined the number with several text strings using another CONCATENATE statement, it didn't seem to work if it wasn't there) |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting Multiple Or Values | Phil H | Excel | 4 | 05-21-2015 04:16 AM |
| Conditional Formatting for values with more than 2 decimals | lynchbro | Excel | 6 | 04-17-2015 06:05 AM |
Copying Conditional Formating
|
lynette | Excel | 2 | 03-06-2015 11:53 AM |
Copying and pasting values with unequal data columns
|
grexcelman | Excel Programming | 5 | 12-05-2014 11:36 AM |
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |