Conditional formatting using text and exceptions

  • Thread starter Thread starter Nic Daniels
  • Start date Start date
N

Nic Daniels

Hi,

I'd like to color a cell using conditional formatting if there is text in it
(sentences etc), but with the exception of single letters (a,b,c,d,etc...).

So:
A
1 a
2 about

The background color of A1 is unaltered.
The background color of A2 is changed into red.

Thank you!
 
Hi,

You don't really define what etc is so I've assumed any single letter.
Select the column of date and apply this conditional format with the coloue
red

=AND(ISTEXT(A1),LEN(A1)>1)

Mike
 
Select the cells from A1 down to wherever, then click on Format |
Conditional Formatting and choose Formula Is rather than Cell Value
Is, and enter this formula:

=AND(ISTEXT(A1),LEN(A1)>1)

Then click the Format button, choose the Patterns tab (for background
colour) and click on Red. Then OK your way out. The formula will
adjust for all the cells in the highlighted block.

Hope this helps.

Pete
 
Back
Top