conditional formatting & countif

  • Thread starter Thread starter Herman
  • Start date Start date
H

Herman

conditional Formating?
Is it only possible to condition format based on the 1st
letter? I would like to conditional format cells based on
the 2nd letter ie cells that contain xNx with N being the
trigger.

also Countif
is there a easier way to input a broken range other than
below I know I can for Sum function is there a way for
countif,
countif(a1:a19,">A")+countif(a23:a27,">A")+countif
(a34:a52,">A").
 
Answer to your first question: yes.

Under cf, Formula Is, use:

=EXACT(MID(A1,2,1),"N")

HTH
Jason
Atlanta, GA
 
Back
Top