1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel Formula/Function

Discussion in 'Business Applications' started by angelsinger125, Jan 14, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. angelsinger125

    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!
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    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
     
  3. angelsinger125

    angelsinger125 Thread Starter

    Joined:
    Jan 14, 2011
    Messages:
    2
    Oh my gosh you are amazing! That is exactly what I was after!!!

    Thank you very much!!!!!!!!
     
  4. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    (y) excellent - let us know if you need further assistance
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/974714

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice