Results 1 to 5 of 5

conditional formatting based on an entire row

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    conditional formatting based on an entire row

    Back again since i got good help yesterday...

    what im looking to do now is color fill a cell based on the value of an entire row.

    What i have is a sheet that shows our current orders. The first column has the order number, which covers two rows. From there, the first row for that order is "Quantity Ordered" and the second row is "Quantity Received". From there, it is about 200 columns long.

    What i am looking to do, is have three variables to determine the color of the cell with the order number in it.

    1. One color to show the order has not come in yet (basically the received line is empty and does not match the ordered line).
    2. One color to show the order is partial (this would be SOME values in the received line match values on the ordered line).
    3. One color to show received (this would be when all the values of the received line, match all the values on the ordered line).

    thanks again!

    P.S. using excel 2007
    Last edited by vaeevictiss; 10-31-2013 at 02:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-16-2012, 04:20 PM
  2. Conditional Formatting entire rows based on data
    By wilsonmedic in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2012, 10:46 AM
  3. [SOLVED] Using conditional formatting to highlight an entire row based on one cell
    By eizanendoso in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2012, 09:59 AM
  4. Conditional formatting an entire row based on colum A cells.
    By sararayne in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-09-2008, 05:51 PM
  5. HOW CAN I APPLY CONDITIONAL FORMATTING BASED TO AN ENTIRE ROW?
    By James M in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2005, 11:45 AM

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