Results 1 to 2 of 2

Formula Required: What is the best way to achieve the following?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-24-2009
    Location
    SCOTLAND
    MS-Off Ver
    Excel Version 2308
    Posts
    151

    Formula Required: What is the best way to achieve the following?

    What is the best way to achieve the following? I’ve attached a part sample of the spreadsheet for reference.
    In this example I want to compare cells B2, B3, B8 & B9 together and B4, B5, B6 & B7. If the difference between any of the cells is greater than 5 but less than 10 then the cell(s) containing the higher value changes to orange. If the value is 10 or more then the cell(s) change to red.
    Additionally, I would like a pop up message to appear for each highlighted cell which could then be acknowledged. (Possibly a different thread?)
    Each column would be entered daily/weekly with only the column reference changing.
    Any help would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1