Solved: Excel Formula/Function

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

angelsinger125

Thread Starter
Joined
Jan 14, 2011
Messages
2
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!
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
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
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,456
(y) excellent - let us know if you need further assistance
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top