View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nic Daniels Nic Daniels is offline
external usenet poster
 
Posts: 23
Default Conditional formatting using text and exceptions

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