conditional formatting gliche.
 

One of my conditional formatting rules is as follows:

If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula calculates the result as 4.497947455 (which
rounded is technically 4.5) and this cell does not format conditionally to
green.

Any suggestions on how to get around that?

conditional formatting gliche.
 

Hi,

It would have helped to see your CF formula but maybe this

=AND(ROUND(A1,2)=4.5,ROUND(A1,2)<=5)

Mike

"mrogozinski" wrote:

One of my conditional formatting rules is as follows:

If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula calculates the result as 4.497947455 (which
rounded is technically 4.5) and this cell does not format conditionally to
green.

Any suggestions on how to get around that?

conditional formatting gliche.
 

Here is the formula:

=(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15)

"Mike H" wrote:

Hi,

It would have helped to see your CF formula but maybe this

=AND(ROUND(A1,2)=4.5,ROUND(A1,2)<=5)

Mike

"mrogozinski" wrote:

One of my conditional formatting rules is as follows:

If value of the cell is between 4.5 and 5.0 then format the cell "green".
The problem is the formula calculates the result as 4.497947455 (which
rounded is technically 4.5) and this cell does not format conditionally to
green.

Any suggestions on how to get around that?