Conditional Format based on 3 other cells.

[Guest]

I'm having a problem doing this.
I have a cell (A5) that I want to be colored RED when the following
condition exits in 3 other cels (G2=4; G3=25; G4=4)
Is this possible?
Also this xls contains about 1000 records and I want all the Cells in Column
A to turn red if that condition exists (noted above exists). Can I copy this
easily to all cells, but not basing it on G2,G3,G4?
The Cell I want the CF on should look at the previous 3 rows in the G column
to see if that condition exists.

 

[PCLIVE]

In conditional formatting, select "Formula is" and then use the formula
below and change the pattern properties as desired..
=AND(G2=4,G3=25,G4=4)

 

[Bob Phillips]

Select the cells in column A starting at A5, and use a condition of Formula
Is and with a formula of

=AND($G2=4,$G3=25,$G4=4)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)