Welcome to NESR! Most features of this site require registration, including replying to threads, sending private messages, starting new threads, and uploading files. Click here to register.

Results 1 to 4 of 4

Excel Help

  1. #1
    Lifer loudbeard's Avatar
    Join Date
    Jun 2013
    Location
    Rehoboth MA
    Age
    37
    Posts
    4,411

    Excel Help


    Quick question for an operation I want to do in Excel - basically I'm making a sheet for our parts inventory. Two columns, one is actual quantity, the second is minimum quantity. What I want to do is compare the two cells and if the actually quantity is less than or equal to the minimum quantity, I want to turn that cell red to indicate an order is needed.

    Things I can already do:
    1.) Create a third column that has a =sum(A$1-B$1) and then apply a less than or equal to conditional formatting to that. I do not want a third column.
    2.) Do each cell individually. I can make it work in that way, but when I try to apply it to the entire column I get an error stating I can only use as a single cell or when applied to a formula.

    TIA

    0 Not allowed! Not allowed!
    I went to MMI I know what Im doing here chief

  2. #2
    Lifer loudbeard's Avatar
    Join Date
    Jun 2013
    Location
    Rehoboth MA
    Age
    37
    Posts
    4,411

    Re: Excel Help

    Nevermind! Immediately after posting this I found format painter. Done!

    0 Not allowed! Not allowed!
    I went to MMI I know what Im doing here chief

  3. #3
    Super Moderator OreoGaborio's Avatar
    Join Date
    May 2004
    Location
    MA
    Age
    40
    Posts
    37,338

    Re: Excel Help

    Use format painter

    0 Not allowed! Not allowed!
    -Pete LRRS/CCS #82 - ECK Racing, TonysTrackDays, Ironstone Ventures
    GMD Computrack Boston | Pine Motorparts/PBE Specialists | Phoenix Graphics | Woodcraft | Street & Competition | MTag-Pirelli | OnTrack Media

    The Garage: '03 Tuono | '06 SV650

  4. #4
    Lifer SteveM's Avatar
    Join Date
    Aug 2009
    Location
    Norwell, MA
    Age
    60
    Posts
    3,092

    Re: Excel Help

    Conditional formatting

    0 Not allowed! Not allowed!

Posting Permissions

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