Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following statement to change colour of one column of my chart:
=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),RGB(0,128,0))
Can you please advise how I can add a nested / multiple IF statement to change another column in the same chart, a DIFFERENT colour. So, I will have two columns which will stand out in different colours to the rest and each other. Thanks guys!
hi
=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),
if(Calendar_Year_Month='2020-08',ARGB(200,200,200,0), RGB(0,128,0)))
hi
=if(Calendar_Year_Month='2020-07', ARGB(179,179,179,0),
if(Calendar_Year_Month='2020-08',ARGB(200,200,200,0), RGB(0,128,0)))
Thank you!