Color Coding for the Summary

[lakshmanvepuri]

Hi Gurus, 

Please let me know how do I achieve this.

SPEND	119000	90040
Budget	100000	100000
Diff	[19000]	[9960]
	+19%	-10%

•For spend

-Red if value exceeds budget, indicating overspend

-Green if value doesn’t exceed

Note:

Summary tab to show the percentage and actual values that exceed or below target.

Text and color coding should follow exactly like shown above.

Thanks a lot.

Regards

Vepuri

[Zhandos_Shotan]

Hi!

Use cell text color expression:

If([SPEND]/[BUDGET]-1>0, Red(), Green())

[lakshmanvepuri]

Hi @Zhandos_Shotan ,,

I got the result earlier  but  not getting like.. as shown in the screenshot (Color Coding)

Thanks

Vepuri