Dynamic background coloring

Extension: Vizlib Pivot Table

Version 3.1.1

QS Version: May 2021

Browser: Google Chrome

Hi there,

I am trying to color the background with the following dimension for lines that are showing as 'Completed'.

=IF(Match(VoyagePeriod,Date(AddMonths(Now(),1),'YYYYMM'),Date(Now(),'YYYYMM')),VesselName&'-'&VoyageReference&'-'&if(VoyageStatus='O','Opened','Completed'))

I have tried using if formulas within the Background Color in both the Styling and Dynamic Styling, however considering the complexity of this dimension i have been unsuccessful.

Appreciate your help.