Posted to microsoft.public.excel.programming

jeremy nickels jeremy nickels is offline

external usenet poster

Posts: 13

If Font.ColorIndex = 5 then . . .

I have a column of data where some of the cells font color is blue and some
is black. I need a macro which looks to see if the font color is blue, then
put a certain text string in another column.

For example: if cell C45 Font.ColorIndex = 5, then put "Embedded" in cell
M45, if not then put "Loose" in cell M45. And so on all the way through the
data. My goal is to be able to filter column M for "Embeded" after I run the
macro.

Can anyone help?

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
DataLabel.Font.ColorIndex vs DataLabel.Text (Private Sub does not work in excel 2003)	God Itself	Charts and Charting in Excel	4	April 22nd 09 03:40 PM
colorindex	Nell Fahey	Excel Discussion (Misc queries)	3	April 28th 05 07:06 PM
VBA syntax for Font & Interior ColorIndex	Dennis	Excel Discussion (Misc queries)	1	November 25th 04 07:38 PM
unable to set the colorindex property of the font class	steve	Excel Programming	3	December 17th 03 02:41 PM
Font and Fill ColorIndex	Frank[_19_]	Excel Programming	3	October 31st 03 01:52 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us