conditional formatting & countif

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").
 
J

Jason Morin

Answer to your first question: yes.

Under cf, Formula Is, use:

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

HTH
Jason
Atlanta, GA
 

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

Similar Threads

conditional formatting update issue 5
Conditional Formatting based on active Named Range; IF Function to VBA 1
Conditional Formatting with COUNTIF 2
Operations with conditional formatting 6
Conditional Formatting 3
Wobbled countif and conditional format Results 9
Conditional Formatting using Small 1
Conditional Formatting 0

Top