Conditional format excel 2003

[JeffD]

Hi, I need help writing a conditional format which says this:

If any cell in column L begins with CSZG then make cells blue. So if cell L17 says CSZG-AB6 then make cells J17, K17, L17, M17, N17 and O17 blue.

Any help is appreciated.

Thanks.

 

[Gerald Higgins]

Select cell J17.
Format, Conditional Formating, Formula Is.

=LEFT($L17,4)="CSZG"

and apply a blue format.

Copy the format to all the other cells that this applies to, for example J1:O100.

 

[JeffD]

I just discovered a problem. Since 2003 only allows 3 conditional formats, I'm not sure how to work this. I have 5 possibilities that could arise. The one I mentioned CSZG as well as CTS8, CTS9, CTR7, BSZN. Each one needs a different colour. Can this be done?

 

[Gerald Higgins]

If they each need a different colour, then you'll need a VBA solution. Try searching this board for VBA and Conditional Formating.

 

[Peter_SSs]

There is a good example and instructions here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90