custom color hues / conditional formatting challange

[michal]

greetings cognoise,

what i have is a fairly straight forward crosstab, with conditional formatting for the cells.
this works great in two colors, red, and green.

my question to you folks is this...

can i have a custom color hue based on the number value in the cell?

so if 1 is a light green, 100 would be dark green
or -1 is a light red, -100 would be dark red.

i admit i've been struggling in having this work as i would like to.

best regards, and thanks for any tips...



EDIT : i've been able to do the above with use of conditional 'string variable' and specifying
conditions for value ranges and then defining them in the conditional browser.
sorry to have troubled you folks.

[tupac_rd]

Thanks for posting the solution.