You have to have that same row active when setting the CF else the formula
else the formula gets adjusted.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Renee" wrote in message
...
Bruce,

It highlighted something but not the right row. It highlighted where H=0
and I = 9999999.0%,

So it got the I column right, but not in combination with the H column.

"bpeltzer" wrote:

In I2, you should be able to set the condition to:
Formula Is, =AND(H2=10,I2=0.2)
You can copy that cell's formatting to other cells in the same column.
--Bruce

"Renee" wrote:

I need to say if Column H cell = 10 and Column I cell is =0.2 then
Highlight Column I yellow.

I can't seem to get the right formula in my conditional formatting
requirements.

Any help you can offer would be greatly appreciated.