I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm assuming
I can use conditional formating for that, but how do I write it?

In the conditional formatting wizard, select Formula Is and enter:

=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"OfficeManager" wrote:

I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm assuming
I can use conditional formating for that, but how do I write it?

No need for =True on the end

=AND(G25,I269%)

Works fine

Mike

"M Kan" wrote:

In the conditional formatting wizard, select Formula Is and enter:

=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"OfficeManager" wrote:

I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm assuming
I can use conditional formating for that, but how do I write it?

Try this...

Select cell D2
Goto the menu FormatConditional formatting
Select the Formula Is option
Enter this formula in the little box on the right:

=AND(COUNT(G2,I2)=2,G25,I269%)

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"OfficeManager" wrote in message
...
I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm
assuming
I can use conditional formating for that, but how do I write it?

Thanks so much. Now, can I count all the cells in column D that have the
conditional formatting of a yellow cell?

"M Kan" wrote:

In the conditional formatting wizard, select Formula Is and enter:

=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"OfficeManager" wrote:

I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm assuming
I can use conditional formating for that, but how do I write it?

=sumproduct((G2:G1005)*(I2:I10069%))
--
David Biddulph

"OfficeManager" wrote in message
...
Thanks so much. Now, can I count all the cells in column D that have the
conditional formatting of a yellow cell?

"M Kan" wrote:

In the conditional formatting wizard, select Formula Is and enter:

=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"OfficeManager" wrote:

I have been reading a lot about conditional formatting. I have cells
in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do
not
both meet the criteria, I don't want anything to happen to d2. I'm
assuming
I can use conditional formating for that, but how do I write it?

Hi,

Counting cells coloured with a conditional format isn't easy but the subject
is covered in depth here.

http://www.xldynamic.com/source/xld.CFConditions.html

If that proves a bit overwhelming then you can count the conditions that set
the conditional format which has the same effect. For example

=SUMPRODUCT((G2:G235)*(I2:I2369%))

Would count that range where both conditions were met on each row.

Mike

"OfficeManager" wrote:

Thanks so much. Now, can I count all the cells in column D that have the
conditional formatting of a yellow cell?

"M Kan" wrote:

In the conditional formatting wizard, select Formula Is and enter:

=AND(G25,I269%)=TRUE
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"OfficeManager" wrote:

I have been reading a lot about conditional formatting. I have cells in D2
that I want highlighted in yellow if g25 and i269%. If g2 and i2 do not
both meet the criteria, I don't want anything to happen to d2. I'm assuming
I can use conditional formating for that, but how do I write it?