Range of Cells Conditional formatting based on:
I have data like this, 3 columns
H I J
1.67 1.37 2.00
4.63 1.37 2.00
2.17 1.25 1.50

If column H Row 1 is < column I row 1 then color cell H1 Red
If Column H1 is J1 then color cell H1 Green
If Column H1 I1 and < J1 then cell color Yellow
I need to continue this for all of H column Rage on a row by row basis, so
next would be Row 2 calcs.
I cannot figure out how to do this in the Conditional formatting, and Im
not sure about the code?
Would really appreciate some ideas..
Oh this is also in a changing pivot table, but the values are averaged to
they maintain the true values to be calcd.
Thanks for help,

--
Regards,

Donica