Block chart color assignments

[#1]

I am trying to set colors in a block chart. I want Company A to be blue, Company B to be green and so on.

I see that you can use if statements however this only gives you a dark shade of the color. Is it possible to pick the the exact color ie RGB (141,90,172)

= if(Catebgoryl='Fuinancial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

[#2 · Accepted solution]

Yes you can use RGB values, its very close to what you have:

Only rather than using color functions, just write in the RGB values.

e.g.

= if(Category='Documentation',RGB(45,127,89),RGB(45,127,89)) for the first color block for 1-6

= if(Category ='Other',RGB(141,90,172),RGB(141,90,172)) for the second color block for 1-6 and so on...

Hope this helps!