Posted to microsoft.public.excel.programming

Gareth[_3_] Gareth[_3_] is offline

external usenet poster

Posts: 109

check font colour

I have a sheet with approx 15,000 rows of data.

I need a macro to check columns C:M to see if any of the cells have blue or
red font in them and if column O is empty.

If this is the case I would like a simple message box saying "Please check
row ???"

Thanks in advance.

Gareth

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
different colour font in same cel	ILMER57	Excel Worksheet Functions	4	April 12th 10 04:57 PM
textBox font colour the same as cell font colour????????	Sophie	Excel Discussion (Misc queries)	4	February 13th 09 10:15 AM
header font colour	Michelle	Excel Discussion (Misc queries)	0	June 4th 08 04:35 PM
Font colour	phil2006	Excel Discussion (Misc queries)	1	July 31st 06 02:15 PM
can the fill colour of a bar be tied to the data font colour data	PaulC	Charts and Charting in Excel	0	June 23rd 06 01:21 AM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us