Conditional Formatting in one column using data in two columns

R

Renee

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.
 
B

bpeltzer

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
 
R

Renee

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.
 
B

Bob Phillips

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)
 
R

Renee

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

Bob Phillips said:
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)
Click to expand...
 
Top