Problem with Conditional Formatting and Greater than or equal too

A

Amanda

I am comparing 2 percentages.....B5 & B6. In Cell C6, I have calculated the
difference. Based on that number, I want B6 color coded.

I am using conditional formatting. If greater than or equal to .01, green.
If less than -.01 red....all other yellow. My problem is that if the
difference is exactly one, it is not changing it to green. Am I missing
something? I have greater than or equal to in the conditional formula.

As always thanks.
 
D

David Biddulph

When you say exactly 1, do you mean exactly 0.1?
Secondly, are you sure that the number is indeed exactly that? How many
decimal places are you displaying?
If you've got a rounding inaccuracy, you may want to use the ROUND function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formating problem. Please help. 7
Conditional Formatting 3
Changing cell colors 1
Excel Conditioning Formatting 3
Conditional Formatting Issue 3
Conditional Formatting 4
colors and conditional format - greater than, less than 5
Conditional Formatting using variable text 4

Top