+ Reply to Thread
Results 1 to 4 of 4

Set row fill color based on conditions.

  1. 10-09-2014, 03:12 PM #1
    Metrazal
    Metrazal is offline
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    241

    Set row fill color based on conditions.

    I am looking for a way to change the row color for multiple rows if a condition exists. In the attached sample, I have two sheets: DATA and DATA2. I need to have the rows fill color changed to orange if the row in column B contains an "x" and if the value in column I matches a value in Range (D:D) in the DATA2 sheet. Any help would be appreciated.

    Thanks,

    Met
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-09-2014, 03:30 PM #2
    judgeh59
    judgeh59 is offline
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Set row fill color based on conditions.

    I used an AND statement and a MATCH statement to achieve this CF...

    HTH...
    Attached Files Attached Files
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....
    Reply With QuoteRegister To Reply
  3. 10-09-2014, 03:44 PM #3
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Set row fill color based on conditions.

    Met,
    The output is on the same sheet
    Attached Files Attached Files
    Last edited by AB33; 10-09-2014 at 03:54 PM.
    Reply With QuoteRegister To Reply
  4. 10-09-2014, 05:34 PM #4
    Metrazal
    Metrazal is offline
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    241

    Re: Set row fill color based on conditions.

    Works great. AB33, you must be a mind reader because I really needed the color Red.

    Thanks for the help..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  2. [SOLVED] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  3. How do i auto fill cell color based on other cells' color?
    By Kchatza in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-22-2012, 05:00 AM
  4. set cell fill color based on multiple conditions
    By StartingOut in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2011, 12:24 AM
  5. Create 2 Totals, One Based On Name And One Based On Name And Cell Fill Color
    By PIPPIBOOKS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-20-2008, 04:41 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1