Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 23
Default Conditional formatting using text and exceptions

Thank you, all of you!


--
Kind regards, Nic


"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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting text Jo Excel Discussion (Misc queries) 3 August 14th 08 03:23 AM
conditional formatting in text box pankaj Excel Discussion (Misc queries) 0 November 1st 07 09:09 AM
Conditional Formatting based on text within a cell w/ text AND num Shirley Excel Worksheet Functions 2 December 22nd 06 01:40 AM
Conditional Formatting based on Text within Text George Lynch Excel Discussion (Misc queries) 3 May 5th 05 07:58 PM
Conditional Formatting of Text... Birmangirl Excel Discussion (Misc queries) 3 January 19th 05 02:45 PM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"