Hi,

I have a worksheet which uses a look up table to populate a results column
with a value. The background colour of these results cells will change
depending on what value is returned from the lookup - the code I have used to
do this is shown below.

However, if a user changes one of the lookup parameters in the worksheet,
the value in the results column does change but the color does not. The code
below shows how I have acheived the conditional formatting - does anyone know
what I can add to this to make the colour change dynamically when the lookup
changes?

Thanks a lot guys

Rob

code appears to be missing
--
Allllen


"BC" wrote:

Hi,

I have a worksheet which uses a look up table to populate a results column
with a value. The background colour of these results cells will change
depending on what value is returned from the lookup - the code I have used to
do this is shown below.

However, if a user changes one of the lookup parameters in the worksheet,
the value in the results column does change but the color does not. The code
below shows how I have acheived the conditional formatting - does anyone know
what I can add to this to make the colour change dynamically when the lookup
changes?

Thanks a lot guys

Rob