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.

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.

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.

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.

I see what my error is!! Thank you so much!!

"Bob Phillips" wrote:

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.