View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amanda Amanda is offline
external usenet poster
 
Posts: 151
Default Problem with Conditional Formatting and Greater than or equal too

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.