Hi Joanne,
if you are trying to shade based on data that changes, just add a secondary data source to your form and use that in your CF.
if you are trying to conditionally change the color of the shading, that can also be done by adding all possible variations into your form and show-hiding based on the data.
might not be as hard as you think ...
:)