Dynamic Change font and or background color in pivot table

[#1]

I am having a problem that I can not find an answer as of yet

I have a pivot table that has a OnHand field and a Required field

I would like to compare the OnHand and Required field and

compare OnHand to Required and change the background cell of OnHand:

if it is less Red

if it is equal Yellow

if it is More Green

I know there is the visual cue area that has something like that but it is hard coded values.

thanks in advance

[morgankejerhag]

If you click on the plus next to your expression On hand and enter the logics in Background color. Something like

if(OnHand < Required, red(), if(OnHand = Required, yellow(), green()))

I would recommend using the rgb() function to find better colors though