Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.

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

  • 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
  • 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
  • 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
  • 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