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

Greater Less or Equal 3
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional formatting with two columns 0
2007 conditional formatting not playing ball 5
Conditional formating problem. Please help. 7
Changing cell colors 1
Conditional formatting for time 2
Conditional Formatting help (2003) 1

Top