Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2017, 06:27 AM
Cosmo Cosmo is offline Copying values that have conditional formatting applied Windows Vista Copying values that have conditional formatting applied Office 2007
Competent Performer
Copying values that have conditional formatting applied
 
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
Reply



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 values that have conditional formatting applied Copying Conditional Formating lynette Excel 2 03-06-2015 11:53 AM
Copying values that have conditional formatting applied Copying and pasting values with unequal data columns grexcelman Excel Programming 5 12-05-2014 11:36 AM
Copying values that have conditional formatting applied Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft