Penny Arcade Forums› Help / Advice Forum
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

Excel Ninjas! Assemble! (SOLVED PLEASE LOCK)

Iceman.USAFIceman.USAF MajorEast CoastRegistered User regular
edited September 2009 in Help / Advice Forum
So, quick question which I think someone can solve easily.

Working with a spreadsheet of construction projects/costs, we're required to 're-program' (re-estimate) a project that received a bid that's +-25% from our original estimate.

Basically if we come up with a project estimate that's $100,000, and the bid comes in at $500,000, we need to re-estimate it.

What I want to do in excel is make a cell show "red" if it hits that 25% difference.

My thought so far is such:

If [origestimate]/[bidestimate] > .25 then cellcolor=red
Partnered with the opposite, of course [origestimate]/[bidestimate] > 1.25 then cellcolor=red

I'm having trouble translating this into excel speak, so I turn to you, the Excel Ninja's.

Iceman.USAF on

Posts

  • Options
    The Count Of Midget FistoThe Count Of Midget Fisto Registered User regular
    edited September 2009
    Format-Conditional Formating

    From there you can set when a Cell changes color and under what conditions

    The Count Of Midget Fisto on
    In Low Orbit Over Budapest
  • Options
    Iceman.USAFIceman.USAF Major East CoastRegistered User regular
    edited September 2009
    Right, got that. I'm having issues with the formula part. Excel doesn't have one pre-built.

    Edit: I think I got it

    =[origestimate]/[bidestimate]<.75, color is red and
    =[origestimate]/[bidestimate]>1.25 color is red

    seems to be working.

    Iceman.USAF on
  • Options
    DeebaserDeebaser on my way to work in a suit and a tie Ahhhh...come on fucking guyRegistered User regular
    edited September 2009
    use conditional formating in the cell where you place your formula.

    -Format
    -Conditional Formatting
    -Win

    Deebaser on
  • Options
    Iceman.USAFIceman.USAF Major East CoastRegistered User regular
    edited September 2009
    I understand how conditional formatting works. What I needed was the formula since it wasn't a 'stock' thing Excel has built in.

    I figured it out already though. Thanks.

    Iceman.USAF on
This discussion has been closed.
Penny Arcade Forums› Help / Advice Forum