0

Conditional format Combo box

I have an Invoice Table with a choice field "Status" which has three options

Outstanding, Paid and Cancelled.

Is there any way to change the background colour using something

like:

 

if today() > "Due Date" then 

Status field is styled(background colour is red)

I have done this in a formula field with:

if today() > 'Due Date' and Status = 1 then
    styled("OVERDUE", "red")
end

but it would be great if I didn't have to add the additional field.

Thanks

Reply

null