How to change the cell background color based on dimension

[dotnetfan]

Hello,

I have a question on straight table. Does it possible to change the cell background color based on dimension?

For example, if the dimension equals to AAAA then all the cells background shows as red and for BBBB, shows as green?

[Arthur_Fong · Accepted solution]

In chart properties > Data >  Columns > Dimension > Background color expression

> if(<Dimension>='<Value>',<Color>)