Conditional Formatting in one column using data in two columns

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

[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

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

[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

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

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

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

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

"Renee" <Renee@discussions.microsoft.com> wrote in message
news:00024E2F-B1B4-44A7-922A-1A620D392629@microsoft.com...
> 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.
> > >

[Renee]

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" <Renee@discussions.microsoft.com> wrote in message
> news:00024E2F-B1B4-44A7-922A-1A620D392629@microsoft.com...
> > 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.
> > > >
>
>
>