I think i am doing something wrong and not able to make it work. Can you please help me here.
If Grey bar % value is less than Blue bar then value of Grey bar should be displayed in Red dynamically.
If Grey bar % value is Greater than Blue bar then value of Grey bar should be displayed in Green dynamically
Blue bar can be in the same color(black).
Along with the above scenario, I have another scenario. Is this possible dynamically in a single sheet?
If Grey % is <=50% of Blue bar % then Red
If Grey % is >55% and <=80% of Blue Bar then Yellow
If Grey % is >90% of Blue Bar then Green