I am trying to add a sum/total to my list report that counts values that are formatted in Green font.
I have several queries to show specific values in green (conditional formatting) and would like to total only these "green" values. I'd like the total to also show in green. (Example: My Conditional Expression is if([Query 1].[Format] = 'Yes') then 'Yes' --The second 'Yes' being the value that turns the text to green.)
Suggestions on how to create the "green" total? Thanks in advance.