+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting formula for shading problem

  1. #1
    Registered User
    Join Date
    08-20-2015
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    11

    Conditional Formatting formula for shading problem

    I am trying to get Columns C-K to shade purple if the lowest number in range isn't duplicated and there is and "x" in column A. If you look at the attached file cell E3 and E16 are shaded purple because they match the number in cell E25, but what I am trying to accomplish is that the cell will only shade purple if it equals E25 and has an "x" in column A

    Question.xlsx
    Last edited by johnsonbj22; 08-25-2015 at 12:59 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,739

    Re: Conditional Formatting formula for shading problem

    Select cell E3, then click on conditional formatting | Manage Rules and choose the rule that gives rise to the purple colour and click on Edit Rule. Now choose Use a Formula... from the bottom of the list and enter this formula in the formula box:

    =AND(E3=$E$25,$A2="x")

    then click OK twice to exit the dialogue box. Excel will automatically adjust the cell references to suit the other cells in the range.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    08-20-2015
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    11

    Re: Conditional Formatting formula for shading problem

    Thanks for the help but I can't seem to get that to work.

    Questionv.2.xlsx
    Last edited by johnsonbj22; 08-25-2015 at 08:31 AM.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,739

    Re: Conditional Formatting formula for shading problem

    That's because the formula referred to A2 instead of A3 - sorry for that.

    I've applied it to your latest file (attached) from C3 to K24, and tidied up all the CF rules.

    Hope this helps.

    Pete
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-20-2015
    Location
    Kansas
    MS-Off Ver
    2007
    Posts
    11

    Re: Conditional Formatting formula for shading problem

    Thanks for the help! I should have seen that myself

+ 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. [SOLVED] Conditional Formatting Rules with Shading
    By Jhertilus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2014, 02:48 PM
  2. [SOLVED] Formula or Conditional formatting for cell shading
    By Jhertilus in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2014, 01:31 PM
  3. [SOLVED] Conditional Formatting - shading weekends
    By jennbates in forum Excel General
    Replies: 2
    Last Post: 05-03-2012, 02:37 PM
  4. Shading Columns with Conditional Formatting
    By Hypnopoison in forum Excel General
    Replies: 1
    Last Post: 04-02-2011, 05:17 AM
  5. Replies: 3
    Last Post: 05-22-2006, 05:42 PM
  6. [SOLVED] conditional formatting-shading
    By Shooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2005, 05:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1