Hi All
I know that I need to write code (VBA) to address this conditional
formatting, but I'm a novice and after reading all the postings on
conditional formatting I can't work it out - please help...

There are 5 conditions and the formatting applies to a growing number of
cells (current range is M14:GR603 - but the number of rows will increase).

The conditions a
If "Retail" is entered in column E of this row, then colour this cell pink
If "Brand" is entered in column E of this row, then colour this cell blue
If "Special" is entered in column E of this row, then colour this cell yellow
If "Generic" is entered in column E of this row, then colour this cell green
If "Other" is entered in column E of this row, then don't colour the cell.

I am using Excel 2000 (if that makes any difference).
Thank for your help
BeSmart