Specific Text formatting, moving decimal but not matching. See sample

[Hiway]

I have another rookie question for all you experts. My last question was answered within 3 minutes...lol

I have a number with 7-8 decimal places (16.04952756) rounded up to 2 decimal places (16.05) but still shows a red highlight because it doesn't match a different cell of 16.05????

Please see sample for a more detailed explanation/question.

Thank You

[6StringJazzer]

Your number is not rounded to 2 decimal places, only the number displayed is rounded. If you use this formula to truly round the number, it turns green:

=ROUND(16.04952756,2)

[Glenn Kennedy]

IF I follow you correctly.


1. delete ALL conditional formatting.

2. repace with

=AND(H22<>"",ROUND(H22,2)>=F22)

and

=AND(H22<>"",ROUND(H22,2)<F22)

and format the range (here applied to H22 to H36).

[Hiway]

6String Jazzer,
The issue with this solution is that I don't have access to the file that is rounding up the numbers. Only to my personal file, which is what I posted the example of. Yes the actual number that the owner of the other file posts is 7-8 decimals long then he/she moves the decimal to the .2 position is what I get automatically to my file. So it looks like the below solution from Glenn Kennedy is what I need to do.
Thank you though for your answer.

[Hiway]

Glenn Kennedy
That's a lot of pig Latin for this amateur!! lol But if this is the solution, what you're saying is that I need to remove the specific text and go with conditional for all the sizes, no matter which ones, 16, 17, 18.... ect

[Glenn Kennedy]

I've never heard the phrase "pig latin" before... but...

Yes. You're then comparing ROUNDED cell values and checking for equality with the value in F.



You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

[6StringJazzer]

I've never heard the phrase "pig latin" before...

Pig Latin is a fake "secret code" language used by kids for fun. I thought it was known in all English-speaking countries. For words beginning with a consonant (or consonant group) you move the consonant to the end of the word and add "ay". For words beginning with a vowel you add "ay" (or "yay" or "hay" or "way" depending on local dialect) at the end. It sounds hilarious and is quite easy to get the knack of it.

[Glenn Kennedy]

Oh.... I do know that... and used it myself Igpay Atinlay.... back in the day... actually back in the decade before the day. I NEVER knew it had a name...

There y'are now... another day, another fact!!