Hi,

1) Select the field to which you want to add conditional background color and press F4 to open the properties window.

2) Then CLICK on the dropdown box next to BackgroundColor and select Expression.

3) In the new window, Write following expression :

=iif(value = something, "Black", "Red")

BackgroundColor will be "Black" if value = something condition is true

else it will be "Red"