different color for different value

[Anonymous]

hello everyone,

i have one pivot table which is contain 3 column e_id,e_name,e_sal ,

i want to give differ color for e_sal based on condition like

i want display e_sal values in blue color who have salary is greater than 90000.

i tried these expression but not working

If(e_sal>90000,'blue()','green()')

&

IF(e_sal>90000, RGB(214,99,252))

thank you

[trdandamudi · Accepted solution]

See the below screen shot and hope this helps...

[Anonymous]

thanks its working,i have one more doubt if i want change all fields value without any condition like ><=, then how it is possible?

[Anonymous]

i tried my second doubt myself and its working

[trdandamudi]

Good to know that it is working...