Generating background colours for codes on a straight table

[Anonymous]

Hi

How do I generate a Background colour for rows on a straight table that were used as a dimension.

Eg.

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue()

[m_woolf · Accepted solution]

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue())))))))

[Anonymous]

Hi,

Go to the dimension, expand that to find the Background color expression and paste the following:

if(LeaveCode='AA',Green(),

if(LeaveCode='DA',Red(),

if(LeaveCode='PA',Yellow(),

if(LeaveCode='AS',Green(),

if(LeaveCode='DS',Red(),

if(LeaveCode='PS',Yellow(),

if(LeaveCode='PH',Blue())))))))