Results 1 to 5 of 5

Formatting cells based on other cells matching

Threaded View

Mokum85 Formatting cells based on... 01-08-2021, 12:53 PM
Glenn Kennedy Re: Formatting cells based on... 01-08-2021, 01:07 PM
Pete_UK Re: Formatting cells based on... 01-08-2021, 01:13 PM
Mokum85 Re: Formatting cells based on... 01-08-2021, 01:30 PM
Glenn Kennedy Re: Formatting cells based on... 01-08-2021, 01:50 PM
  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

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