Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
I'm not sure Excel is even set up to do this. Basically I have a chart for work that tracks an agency's monthly spending. We have a column for total contract allotment, and a column summing their actual expenditures. I want to know if we can set it up to have Excel automatically shade the cell red when the actuals are greater than 20% of the allotment. I hope this makes sense and/or is possible!

Thanks for your help!
 

·
Super Moderator
Joined
·
65,526 Posts
the cell would be easy using conditional formating - changing a graph / chart will be different

lets have some dummy data loaded on a spreadsheet and we can set it up and then post how to do it

what version of excel

otherwise look up conditional formatting

this shows using a %
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/aa93f3232468b8a9

this may help also
http://www.cpearson.com/excel/cformatting.htm
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top