Previous Topic Next Topic

Conditional Format - More than 3 colours

Closed
Jaya - Jan 14, 2009 at 07:30 PM
dellvostro Posts 18 Registration date Wednesday September 10, 2008 Status Member Last seen May 12, 2009 - Jan 15, 2009 at 04:19 AM
Hello,

I want to do a conditional formatting.

It relates to colouring range of cells. There are more than 3 colours so I can't use Excel Conditional Formatting.

For example:

A1 = F06
then colour in B1:D1 is RED.

How can I do that through Macro?

Where can I find the colour codes?

Thank you.

Regards,
Jaya
Related:

1 response

Answer 1 / 1
dellvostro Posts 18 Registration date Wednesday September 10, 2008 Status Member Last seen May 12, 2009
Jan 15, 2009 at 04:19 AM
hi,

try this link to get more information about the topic you are searching for:

http://en.allexperts.com/q/Visual-Basic-1048/activating-conditional-formatting-macro.htm
1