Simplified Conditional Macro

**martinez_pedro** · 03-27-2011, 12:20 PM

Is there a way to simplified this conditional macro?

Before hand thank you for all help provided

Please Login or Register  to view this content.

**HSV** · 03-27-2011, 01:07 PM

This does the same?

Please Login or Register  to view this content.

**Richard Buttrey** · 03-27-2011, 01:09 PM

Hi,

Perhaps something like...

Please Login or Register  to view this content.

I also question whether you need to format the whole of column I. Won't just the relevant range you're using suffice?

**martinez_pedro** · 03-27-2011, 05:50 PM

So try both suggestion and i combine them and this is what i came up with
it when from 577 lines of code to 150
Thanks guys for you help

Please Login or Register  to view this content.

**shg** · 03-27-2011, 06:49 PM

Why not put all those names in a range and have just one format condition with a simple MATCH formula?

**martinez_pedro** · 03-27-2011, 10:31 PM

Hey shg can you give me an idea how to piece together this formula?
Thanks

Re: Simplified Conditional Macro