Posted to microsoft.public.excel.misc

dan

external usenet poster

Posts: 866

Conditional Formatting - Excel 2003

Is there a way to use conditional formatting on a text field with leading
zeros?
For example, I have a department number of 00123 and would like to highlight
all instances of this number. When entering directly in to the dialog box,
the zeros are dropped.

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 Formatting for Excel 2003	Lee	Excel Discussion (Misc queries)	3	May 31st 08 01:29 AM
Conditional formatting excel 2003	[email protected]	Excel Worksheet Functions	1	April 14th 08 11:43 AM
Excel 2003: Conditional Formatting with Subtotals	oceanmist	Excel Discussion (Misc queries)	1	November 27th 07 09:47 PM
Conditional Formatting: Excel 2003 vs. 2007	JP	Excel Worksheet Functions	3	January 13th 07 11:33 PM
Excel 2003: Conditional Formatting	oceanmist	Excel Discussion (Misc queries)	3	September 20th 06 10:55 PM

All times are GMT +1. The time now is 01:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us