software

I need to say if Column H cell gt;= 10 and Column I cell is gt;=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(H2gt;=10,I2gt;=0.2)
You can copy that cell's formatting to other cells in the same column.
--Bruce

quot;Reneequot; wrote:

gt; I need to say if Column H cell gt;= 10 and Column I cell is gt;=0.2 then
gt; Highlight Column I yellow.
gt;
gt; I can't seem to get the right formula in my conditional formatting
gt; requirements.
gt;
gt; Any help you can offer would be greatly appreciated.
gt;

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.

quot;bpeltzerquot; wrote:

gt; In I2, you should be able to set the condition to:
gt; Formula Is, =AND(H2gt;=10,I2gt;=0.2)
gt; You can copy that cell's formatting to other cells in the same column.
gt; --Bruce
gt;
gt; quot;Reneequot; wrote:
gt;
gt; gt; I need to say if Column H cell gt;= 10 and Column I cell is gt;=0.2 then
gt; gt; Highlight Column I yellow.
gt; gt;
gt; gt; I can't seem to get the right formula in my conditional formatting
gt; gt; requirements.
gt; gt;
gt; gt; Any help you can offer would be greatly appreciated.
gt; gt;

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)

quot;Reneequot; gt; wrote in message
...
gt; Bruce,
gt;
gt; It highlighted something but not the right row. It highlighted where H=0
gt; and I = 9999999.0%,
gt;
gt; So it got the I column right, but not in combination with the H column.
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; In I2, you should be able to set the condition to:
gt; gt; Formula Is, =AND(H2gt;=10,I2gt;=0.2)
gt; gt; You can copy that cell's formatting to other cells in the same column.
gt; gt; --Bruce
gt; gt;
gt; gt; quot;Reneequot; wrote:
gt; gt;
gt; gt; gt; I need to say if Column H cell gt;= 10 and Column I cell is gt;=0.2 then
gt; gt; gt; Highlight Column I yellow.
gt; gt; gt;
gt; gt; gt; I can't seem to get the right formula in my conditional formatting
gt; gt; gt; requirements.
gt; gt; gt;
gt; gt; gt; Any help you can offer would be greatly appreciated.
gt; gt; gt;
I see what my error is!! Thank you so much!!

quot;Bob Phillipsquot; wrote:

gt; You have to have that same row active when setting the CF else the formula
gt; else the formula gets adjusted.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Reneequot; gt; wrote in message
gt; ...
gt; gt; Bruce,
gt; gt;
gt; gt; It highlighted something but not the right row. It highlighted where H=0
gt; gt; and I = 9999999.0%,
gt; gt;
gt; gt; So it got the I column right, but not in combination with the H column.
gt; gt;
gt; gt; quot;bpeltzerquot; wrote:
gt; gt;
gt; gt; gt; In I2, you should be able to set the condition to:
gt; gt; gt; Formula Is, =AND(H2gt;=10,I2gt;=0.2)
gt; gt; gt; You can copy that cell's formatting to other cells in the same column.
gt; gt; gt; --Bruce
gt; gt; gt;
gt; gt; gt; quot;Reneequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I need to say if Column H cell gt;= 10 and Column I cell is gt;=0.2 then
gt; gt; gt; gt; Highlight Column I yellow.
gt; gt; gt; gt;
gt; gt; gt; gt; I can't seem to get the right formula in my conditional formatting
gt; gt; gt; gt; requirements.
gt; gt; gt; gt;
gt; gt; gt; gt; Any help you can offer would be greatly appreciated.
gt; gt; gt; gt;
gt;
gt;
gt;