G
Guest
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
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