View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Conditional formatting using text and exceptions

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

"Nic Daniels" wrote:

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!
--
Kind regards, Nic