Friday, July 25, 2014

yogi_Apply Conditional Formatting In Column D To Highlight Entries That Match Upto 7th Decimal Place

                            Google Spreadsheet   Post  #1708
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul-25-2014
post by Emmett Armstrong:
Hi Yogi,
I'm wondering if you can help with the issue I've been having in this post:
New google sheets changes rounding procedure?
I'm trying to use conditional formatting based on a minimal decimal addition to cue formatting. For example: 10 turns green when a formula adds .0005858. Conditional formatting looks for 5858, and thus turns green when it finds the value in the decimal place.

The problem I'm having is in the new google sheets. This feature does not seem to work because of a new automatic rounding format for numbers. As I change the amount of decimal places displayed, rather than just displaying a larger or smaller amount of VISIBLE decimal places, the actual VALUE of my cell is changed. .0005858 starts rounding up to .000586 and then to .00059, .0006 etc. The conditional formatting sees .0006 instead of the real value of .0005858. By the time I get to the desired result of no decimals, I've lost formatting. 

 This causes quite a problem because I don't want to have to display 10 decimal places on my spreadsheet. Anyone have ideas?