Posted to microsoft.public.excel.worksheet.functions

dazp1970

external usenet poster

Posts: 2

Conditional formating for text

I am using conditional formatting to change the colour of cells that contain
text.

What I am trying to do is format cells so that those that do contain text
(any text) are coloured one colour, and blank cells are coloured a different
colour.

I don't want to change the background colour of my sheet though.

Any suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
text conditional formating	hannatrip	Excel Worksheet Functions	6	March 12th 07 04:06 PM
CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS	Twiggy	Excel Worksheet Functions	4	April 12th 06 09:13 AM
Conditional formating with TEXT	Steve M	Excel Discussion (Misc queries)	4	February 18th 06 05:11 PM
Conditional formating based on text	mango7	Excel Worksheet Functions	6	February 8th 06 10:11 PM
Conditional Formating when result is text	Lary	Excel Worksheet Functions	1	December 16th 04 02:13 AM

All times are GMT +1. The time now is 11:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us