Conditional Formating
 

Hi Every one,
I have a sheet which currently uses Excel 2000 conditional formating
to change the cell color based on a formula that comes from another
sheet. So depending on the alphabet result that comes from the formula
the cell's color changes
for upto 3 results
L-Yellow
M-Orange
H-Red

But now we have a new requirement which says a new
N-Green is to be added.

I have tried the macro Worksheet_Change suggested by others for the
worksheet but it only works when there an direct addition to cell and
some key pressed. Can any one suggest another alternative, I am new to
VBA so any help is appreciated.