Conditions based on the colour of listbox

[#1]

Hi,

I have a sales trend report with 2 listboxes on my sheet (financial year and year)

The columns are

• Current Year or FinancialYear
• Current Year or FinancialYear -1

"if(isnull([FinancialYear]), sum({<[Year]={'$(vCurrentYear)'}>}[val]), sum({<[FinancialYear]={'$(vCurrentFY2)'}>}[val])))"

Is there any way around this? Can I filter a listbox based on colour? For e.g. if colour = 'green'??

Thanks

[#2]

Does anyone know anything about the above issue?

Any help would be greatly appreciated.