Posted to microsoft.public.excel.misc

Wanna Learn Wanna Learn is offline

external usenet poster

Posts: 318

Conditional Formating and Mid

Hello This is my conditional formatting formula =MID(B9,3,2=19) and it
does not work. column B has numbers such as 2D1985. what I want to do is
if the number 19 appears after the first two digits(in this case 2D) to
highlight the cell in grey. thank you

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	Jithu	Excel Discussion (Misc queries)	1	September 27th 07 01:01 PM
Conditional Formating	markythesk8erboi	Excel Worksheet Functions	2	September 24th 07 11:02 PM
conditional formating #N/A	Dave	Excel Worksheet Functions	2	January 12th 07 03:07 PM
Conditional Formating	Dan	Excel Worksheet Functions	0	March 26th 06 11:45 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 10:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us