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

OR or AND?

I think AND, so use a CF formula of

=AND($A$1<A2,A22)

and count them with

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

--
HTH

Bob

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

"Eric" wrote in message
...
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,

What is the CF Formaula?

"Bob Phillips" wrote:

OR or AND?

I think AND, so use a CF formula of

=AND($A$1<A2,A22)

and count them with

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

--
HTH

Bob

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

"Eric" wrote in message
...
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

The Conditional Formatting formula.

--
HTH

Bob

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

"Eric" wrote in message
...
Bob,

What is the CF Formaula?

"Bob Phillips" wrote:

OR or AND?

I think AND, so use a CF formula of

=AND($A$1<A2,A22)

and count them with

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

--
HTH

Bob

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

"Eric" wrote in message
...
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