how to get one columns back ground color to red

Hi all
In attendance report i need to show the back ground color as red if the column is sundayRight click the field, choose format field, select the Border tab, press the 'x-2' button to the right of the background boxes, enter a formula like
if {table.field} = 'Sunday' then crRed else crNoColor