Conditional Formatting in one column using data in two columns
 

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.

Conditional Formatting in one column using data in two columns
 

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.

Conditional Formatting in one column using data in two columns
 

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.

Conditional Formatting in one column using data in two columns
 

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.

Conditional Formatting in one column using data in two columns
 

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.