+ Reply to Thread
Results 1 to 5 of 5

Formatting cells based on other cells matching

  1. #1
    Registered User
    Join Date
    10-18-2016
    Location
    Amsterdam
    MS-Off Ver
    2013
    Posts
    11

    Formatting cells based on other cells matching

    Hi All,

    I am looking for a way to highlight a cell with Conditional Formatting when it meets certain requirements.

    So in the attached file i have a budget overview (adjusted version) with Supplier budgets per month. Now only January showing.
    Now as you can see there is a 100 euro budget in January (C3) for Supplier_A (A3) and nothing for Supplier_B (A4), so its Supplier_A that is interesting. What i want to achieve is the following:

    I want cell A3 to be automatically highlighted during the real life month January as there is a budget filled in for that month under cell C3. Cell B1 has the formula =MONTH(A1) showing the current month and cell C1 has "January" as text so that should be a match.

    Hopefully somebody can tell me if this is even possible.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formatting cells based on other cells matching

    One way:

    =INDEX($C3:$Y3,MATCH(TEXT($A$1,"mmmm"),$C$1:$Y$1,0)+2) > 0
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

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

    Re: Formatting cells based on other cells matching

    It would help if you showed a few more months in your example file, so we can see how you plan to lay your data out. I presume that when we get to February you would want the cells in column A to be highlighted only if there is a budget amount in the column for February, but which column do you intend to use for that (or for March, and so on) ?

    Pete

  4. #4
    Registered User
    Join Date
    10-18-2016
    Location
    Amsterdam
    MS-Off Ver
    2013
    Posts
    11

    Re: Formatting cells based on other cells matching

    Ok that looks interesting that formula
    I extended the months as in the original file it goes till December and yes the idea is that in column A it does highlight if budget is set on that month.
    Attached Files Attached Files

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Formatting cells based on other cells matching

    Try it now. Your formula in A2 was incorrect, which may have thrown you off slightly. Add a budget for another month in the future and change the date in a1.
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 11-23-2020, 11:52 AM
  2. [SOLVED] Please Help, need a formula to count cells based on dates in 2 other cells matching.
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2017, 03:20 AM
  3. [SOLVED] Trying to return value based on two cells in one row matching two different cells
    By bellicusa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2015, 11:14 AM
  4. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  5. [SOLVED] lookup a range of cells and populate specific cells based on matching data
    By RobertM01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2014, 08:18 PM
  6. Help matching cells and then looking at other column based on those matching cells
    By Ppessina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2013, 02:37 PM
  7. Replies: 2
    Last Post: 08-27-2011, 03:05 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