Hi All,
I am not very good at excel, but I am trying to clean up our corporate template for contract budget checks. What I am trying to do is turn the Variance cell green if the tender is within the approved budget or red if the tender exceeds budget. Our current way of displaying this is with brackets for a negative. I was told its somewhere in the conditional formatting by a colleague, but I couldn't figure it out.
Any help would be appreciated!
Thank you.
Capture.PNG
Bookmarks