Conditional formatting issue

[chriscavsib]

Hi all
We have a spreadsheet which has columns of data extracted from other sheets via formula.

What we want to do is have a conditional format on one column if the cell value is higher than the cell value in the other column.

Currently, when we've tried it, the formula is picking up various cells.. Most of which aren't what we want.
We've tried changing the format of the cells in case they we're numbers but that isn't the issue.
We've tried things like =IFE3>F3 etc but can't seem to get it to function

Any ideas?

Thanks in advance

 

[Joe4]

You are welcome!

If you aren't sure where those fractional amounts are coming from, it could be the famous "Floating Point Arithmetic" issue!
That is explained in detail here: Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps

As you can see from that article, one way around it is to round the numbers off, like we did.