+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting based on the conditional format of other cells

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    New York
    MS-Off Ver
    2016
    Posts
    1

    Question Conditional formatting based on the conditional format of other cells

    I am just starting to use conditional formatting and need some help. I added a picture below for some context. I am looking to create a conditional formatting rule that colors the town name only when both the average sale and close rate are both colored due to their own conditional formatting rules. What kind of formula would I need to do this?


    excel forum pic.png
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    08-18-2016
    Location
    Earth
    MS-Off Ver
    2010 and 2013
    Posts
    64

    Re: Conditional formatting based on the conditional format of other cells

    You can use the AND function and combine the arguments from average sale and close rate to apply the condition to the city.

+ 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. Conditional Formatting Based on Adjacent Cell *Format*
    By MacroPolo in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 09:59 AM
  2. Replies: 2
    Last Post: 12-05-2014, 07:15 AM
  3. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  4. Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  5. [SOLVED] Workaround to Conditional Formatting based on a Format of another cell
    By sarkman22 in forum Excel General
    Replies: 5
    Last Post: 05-10-2013, 01:24 PM
  6. Using Conditional Formatting to format range based on one cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2012, 09:50 PM
  7. Replies: 2
    Last Post: 12-21-2011, 06:01 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