Conditional Formatting

[Beh162]

I'm trying to conditional format a group of data and it seems to be working, except one cell colored the wrong way and I'm not sure why?
D11 & E 11 are the first two columns which has 7 & 13.

The one that didn't color correctly is towards the bottom which colored red. The two numbers are 9 and 9. Which if it's greater than or equal to the number to the right, it should of colored Green.

 

[yky]

Expand the numbers to show three decimal places to see if 9 is actually 9.000 or, maybe, 8.999.

 

[Beh162]

Expand the numbers to show three decimal places to see if 9 is actually 9.000 or, maybe, 8.999.

Ahh you got it! That cell is based on a formula and inside the formula it's rounding the number up. Is there something I can do to adjust around the fact that the formula is rounding. I actually want the rounded number

 

[jtakw]

Cross posted here: https://www.excelforum.com/excel-fo...multiple-cells-with-formulas.html#post4931980

 

[Macropod]

Beh162 : Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

I note this is not the first time you've been taken to task for cross-posting without providing the relevant links. Please don't make a habit of this...