Wildcard In Condtional Formatting.

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

Guest

Hello, Good Evening & Welcome

I have over 300 cells that can begin with any one of 3 letters. The rest of
the cells can be anying.
I am trying to conditionally format them so that each letter has its own
colour.
In the condtions box, I am selecting "formula is" and entering ="F*", but it
is not working.
Is this right or wrong. Can you actually have wildcards in CF.

Thanking you in anticipation.
 
Try something like this as one of your conditions ... It needs to be a formula

=LEFT(A1,1)="F"
 
Using the "formula is" I got results using this formula:
=LEFT(B3,1)="F"

....where B3 is the cell in question. Or, you could enter all three
letters like this:
=OR(LEFT(B3,1)="F",LEFT(B3,1)="G",LEFT(B3,1)="H")
 

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

Cell referencing for condtional formatting 3
condtional formatting 2
Conditional formatting in 2007 3
conditional formatting 2007 - begins with 3
Can you conditionally format a whole row based on data in one cel 1
Copy condtional formatting in XL2007 for Windows 1
Condtional Formatting 2
Excel Wildcard in Excel array formula 0

Back
Top