I am having issues conditionally formating a crostab in Crystal.
In this example, I would like to be able to change the BG color of the on hand based on the value of min or max.
for example: belom min: crred ... close to min: cryellow etc.etc.
Min | On Hand | Max
25 98 100
25 201 100
25 18 100
25 51 100
This is too complex for the highlight expert. So the only place I know of to do this is conditionally format the background in the boder tab under format field. I cant seem to get the syntax right though.
Any help would be appreciated.