Using multiple IF statement on chart background colour

[jlampard40]

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!

[lironbaram · Accepted solution]

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)))

[jlampard40]

Thank you!