RGB() values of Some colors

[niha]

Hello,

I created Bar Chart and I want to give color like below. I have written condition color like below.

if( [Service Year Number]= '2014', rgb(-192,192,192),
if( [Service Year Number] = '2015', rgb(255, 0, 0),
if( [Service Year Number]= '2016', rgb(100, 149, 175),
if( [Service Year Number]= '2017', rgb(100, 149, 150),
if([Service Year Number] = '2018', rgb(100, 110, 150),
if([Service Year Number] = '2019', rgb(100, 110, 150),'grey'))))))

But my RGB code is not correct. I want to know the RGB code of following col. Please suggest.

Regards,

Niha

[rogerpegler]

Apologies I thought I'd used RGB with the hex code, but obviously not - in places you can just use the hexcode instead of RGB. 

eg =if(1=1,'#9999ff','#0101ff')

In any case, still use the colour pallett to find your desired hex code and convert it to rgb with each pair eg #0000ff is 0 & 0 &  255.