Conditional formatting using a macro.

Hi All,

I'm designing a holiday chart in work, and am using conditional formatting to colour cells.

The problem is I have more than 3 conditions. Consequently I need to use a macro.

I have the following code, but have a couple of questions.

Please Login or Register  to view this content.

My range select isn't working as I'd like? I need to select 2 individual ranges at the same time?

G8:GE30 and G35:GH57 but based on what is entered above excel seems to be selecting G8:GH57? Can anyone tell me how to fix this?

Also

Can anyone advise how to include a second condition e.g. if the letter L is inserted in a cell, i'd like to shade it grey?

I'd appreciate any help!
Many thanks,
John

Jay3,

This works for me:

Please Login or Register  to view this content.

Have a great day,
Stan