Hi all I have a problem trying to work out how to set up the right Conditional Formatting formula for this problem
essentially i only need to compare cell A1 with B1.
They both have betting odds in them.
The odds actually represent probably (worked out by 1/cell value) --- (i.e. $2.00 = 1/2 = 0.5 Probability)
I want cell B1 to highlight when the PROBABILITY is greater than 0.1 to that of cell A1.
Hopefully someone can help thanks!
Bookmarks