VBA Conditional Formating

[Rob.Marchel]

Hi Guys,

I have a rollbook that has been validated to take a number of markings.

What I would like it to do is when the cell value is say "IA","IB","IC", the cell color is changed to black and every cell in that row until the 31st day is blacked out.

I would use traditional conditional formatting, but there are about 8 different values that need to able to do this.

Cheers,

Rob.

[FDibbins]

Are you using 2003 as your profile says? (reason I ask is that at 1 point, the server was putting in 2003 by default)

[Rob.Marchel]

Hi Ford,

Yes, I'm using 2003, my workplace's policy on software currency is non existant. lol

Cheers,

Rob.

[FDibbins]

OK then if you need 8 rules (colors), then VBA is the way to go. 2003 only allows 3 rules, unfortunayely VBA is not my strong suite

[Rob.Marchel]

Bump.

I'll add more information if this will help with you VBA gurus.

Range is I6:AM205
If any cell value = "IA","IB","IC","ID" etc.
Then the cell containing "IA","IB" etc. and any cell to the right of it until the end of the range will be black.

Thanks again!

[Cupragsw]

I have had the same issue and they have come up with a soultion on this thread

http://www.excelforum.com/excel-prog...condtions.html

[Rob.Marchel]

Please Login or Register  to view this content.

So this will give the me conditional formatting I require for single cells classified as above.

Is there away to write a VBA code that does the following:

Check cell to the right for conditional formatting, copy if yes, contained within a range?

Cheers,

Rob.