+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting with Color of Whole Row Based on Different Values

  1. #1
    Registered User
    Join Date
    04-27-2023
    Location
    Chicago, IL
    MS-Off Ver
    365
    Posts
    1

    Conditional Formatting with Color of Whole Row Based on Different Values

    I have a drop-down field with 6 different values, and based on each value, whichever one is selected, I want it to highlight the entire row of data (approximately 10 columns) in one unique color based on the value in the drop-down, and I want to apply it to the whole worksheet. Drop-down values and the colors I want their entire rows to turn if their values are selected are:

    Prospect - gray
    Lost - pink
    Tentative - 1st Option - light blue
    Tentative - Space Available - light green
    Waived - orange

    Each row represents a different account and so depending on which value in the drop-down above is selected, I would want each row to take on the color assigned to the value in that one cell in its row.

    How do I create the Conditional Formatting formula that turns a whole row one unique color based on its unique value in one cell, so that I could have one row that's gray, one that's pink, one that's orange, etc., based on the values selected?

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,641

    Re: Conditional Formatting with Color of Whole Row Based on Different Values

    So, You need 5 single conditioning formating formulas
    see attachment
    Attached Images Attached Images
    Attached Files Attached Files
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum based on color given by conditional formatting
    By JulieVDAA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2020, 01:24 PM
  2. Conditional formatting based on color
    By dousoume in forum Excel General
    Replies: 3
    Last Post: 09-02-2020, 05:11 AM
  3. [SOLVED] Conditional Formatting for (Duplicates + Color based Values)
    By mimranflmsa in forum Excel General
    Replies: 4
    Last Post: 05-10-2019, 03:50 PM
  4. COUNTIF based on conditional formatting Color
    By mikemccraney in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-08-2018, 06:37 PM
  5. Replies: 2
    Last Post: 09-02-2018, 01:09 PM
  6. Replies: 6
    Last Post: 12-30-2013, 11:46 AM
  7. Conditional Formatting of Font Color based on Values in another cell
    By dpcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2012, 07:49 PM

Tags for this Thread

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