Need 2 Formulas
Results 1 to 2 of 2

Thread: Need 2 Formulas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2015
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need 2 Formulas

    I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5%

    Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5?
    Is there a way D1 can be Red if the difference is over our goal

    Example...C1 will be 22.00% (that stays black) D1 would be .5% (we are .5 ahead of target. It stays Black)
    But if C1 is 23.00% (we exceeded our goal and I'd like this to be Red) and the D1 would be -.5% (and I want that Red)

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,086
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Need 2 Formulas

    You can just use Conditional Formatting on cells C1 and D1:

    Conditional Formatting formula on cell C1:
    Code:
    =C1>22.5%
    Conditional Formatting formula on cell D1:
    Code:
    =D1<0
    and choose your red formatting options.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •