Custom color in Linear Gauge

[#1]

Hi Experts,

This is a simple fuction we are trying to have custom color in our chart based on the metric selected. (like Metric =ABC Red etc)

used in a linear gauge insde a straight table.

This below code is not giving the different colors as desired.

if(Metric='ABC',ARGB(191,3,184,91),if(Metric='XYZ',ARGB(242,242,188,102),if(Metric='MNP',ARGB(241,166,192,241),if(Metric='WHO',ARGB(217,217,151,163),if(Metric='FNP',ARGB(244,244,155,69))))))

Please help.

Regards,

Roy