i want to change the cell background colour, when calculation field is applied.
IF SUM([Sales])> 5000 THEN 'Green'
ELSEIF SUM([Sales]) > 300 THEN 'Red'
ELSE 'Yellow'
END
but only the values colour is changing. what to do?
Hi Babji
There is a previous discussion here which maybe helpful
ps. we cant open .twb files, they need to be .twbx (packaged workbook, which contains the source data)
Cheers
Mark