Formating

E

Eric

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
 
B

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

Eric

Bob,

What is the CF Formaula?

Bob Phillips said:
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)
 
B

Bob Phillips

The Conditional Formatting formula.

--
HTH

Bob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top