Formating

[Guest]

Hello all,
Is it possible to write into a macro a conditional format? What I want to
do is if the cell A3 is <A1 or >2 then turn A3 red and bolded. After that I
want Cell A5 to count the Red Bolded cells.

A1 A2 A3
A5
80 98 95 ~> this cell would be fine as it is 0

A1 A2 A3
A5
80 98 75 ~> this cell would be Red and Bolded 1

Hope someone can help....Thank you

Eric

 

[Bob Phillips]

OR or AND?

I think AND, so use a CF formula of

=AND($A$1<A2,A2>2)

and count them with

=SUMPRODUCT(--(A2:A4>$A$1),--(A2:A4>2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Bob,

What is the CF Formaula?

OR or AND?

I think AND, so use a CF formula of

=AND($A$1<A2,A2>2)

and count them with

=SUMPRODUCT(--(A2:A4>$A$1),--(A2:A4>2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

The Conditional Formatting formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)