Conditional formatting on LISS based on Collect() line item value
I have a financial reporting module with only one line item, Collect, which as the name suggests is collecting values from a LISS with the Collect() function. The LISS is a fake versions list that has actual, budget and actual vs. budget as list members. I now want to do conditional formatting to the "Actual vs. Budget" LISS list member so if the actual is below budget the numbers are red. I understand how you normally format line items but since I now want to format a specific list item based on the collect I'm not sure how to get this done since any rule I create for the Collect() line item will impact all list items.