Posted to microsoft.public.excel.programming

smonczka

external usenet poster

Posts: 29

Conditional Formating...

Does anyone know how to use wildcards with Conditional Formating?

I need to highlight all ROWS in a spreadsheet CONTAINING the word
"Total".

Normaly I would use conditional formating with the following
formula ....

Formula is =$A1="Total" but this will only pick up exact matches.

Thanks,
Steve

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
Conditional formating	Mandy	Excel Discussion (Misc queries)	2	March 26th 09 07:49 PM
conditional formating using mod	gtslabs	Excel Discussion (Misc queries)	1	March 19th 09 06:55 PM
Conditional FOrmating	Maggie[_4_]	Excel Worksheet Functions	2	November 29th 07 01:59 PM
Conditional Formating	Zee	Excel Discussion (Misc queries)	5	August 10th 06 02:56 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM

All times are GMT +1. The time now is 11:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us