Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Color Coding for the Summary

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

 

Labels (2)
2 Replies
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

Use cell text color expression:

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

lakshmanvepuri
Creator
Creator
Author

Hi @Zhandos_Shotan ,,

 

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

lakshmanvepuri_0-1617464873431.png

Thanks

Vepuri