View Single Post
 
Old 02-24-2017, 06:27 AM
Cosmo Cosmo is offline Windows Vista Office 2007
Competent Performer
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

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)
Reply With Quote