Conditional Formatting of same cell - 7 conditions

[theirishdancer]

Hi,

I'm trying to implement multiple conditional formatting in Excel 2003 for same cell. I've found threads that address similar issues, but I don't understand some of the syntax, and thus am unable to adjust it to my needs. Here is what I need done:

In a range of cells, e.g. B4 to AF9, do the following actions, depending on the content of the cell:

If Cell value is "H", then make the color of the cell, and font Neon (ColorIndex = 4?)
If Cell value is "N", then make the color/font of the cell Yellow (ColorIndex = 27?)
If Cell value is "S", then make the color/font of the cell Red (ColorIndex = 3?)
If Cell value is "C", then make the color/font of the cell Purple (ColorIndex = 17?)
If Cell value is "E", then make the color/font of the cell Gold (ColorIndex = 40?)
If Cell value is "R", then make the color/font of the cell Blue (ColorIndex = 32?)
Otherwise, leave cell blank

I found this post that relates: http://www.excelforum.com/excel-prog...ther-cell.html but I'm not sure how it defines the range of cells. In particular, what does "If Not Intersect(cell, Range("E:E,J:J,O:O,T:T")) Is Nothing Then" mean?

Any help would be much appreciated! Thanks