Forum Discussion
Solved
Matrix color formatting based on Column
Hi All, I am using the matrix visual with a single field (FY) in Row and multiple Values in Values section. I am looking to get a Font color formatting on it as in attached: For the FY column FY20...
see attached.
Manipulating the font color of the cells is much easier to do. However I do not understand your logic rules at all. You also have no negative values in your sample data. Can you please explain the rules again and show all scenarios?
Thank you, forget about the negative values, this sample i gave doesn't have negative, sorry for confusion, Now all i need is simply:
if FY (FY2015) then I need the row values of (2012,2013,2014) to be colored in "Blue" else all other row values in "Green",
same way if FY (FY2016) then I need the row values of (2013,2014,2015) to be colored in "Blue" else all other row values in "Green",
same logic follow after every FY.