Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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,

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)
 
The Conditional Formatting formula.

--
HTH

Bob

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