![]() |
|
#1
|
|||
|
|||
![]()
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) |
![]() |
|
![]() |
||||
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 |
![]() |
lynette | Excel | 2 | 03-06-2015 11:53 AM |
![]() |
grexcelman | Excel Programming | 5 | 12-05-2014 11:36 AM |
![]() |
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |