+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting not applying to all cells in range

  1. #1
    Registered User
    Join Date
    10-05-2022
    Location
    Gastonia, NC
    MS-Off Ver
    365
    Posts
    3

    Conditional Formatting not applying to all cells in range

    I am trying to build a spreadsheet that will track numerator / denominator and value for multiple tasks and tracked each month. I use 1 cell to identify what the current month is, and a separate tab to assign month names to numbers (January = 1, February = 2 etc.). Because forumlas exist in the cells for the months that are yet to arrive, I want them to appear blank. So I've written a conditional format that states if the current month is >= the current month to either show or not to show the data in the cell.
    The Formula: '=IF(VLOOKUP($C2,MRID!$B2:$C14,2,FALSE)>=VLOOKUP(Info!O3,MRID!$B2:$C14,2,FALSE),"Show","No")'
    The Conditional: =Q$1="No"
    Applies to: =$F$5:$H$6

    There are six cells in two rows that are being used. Row 5 cells F, G, and H are merged and centered. Row 6 cells F, G, and H are NOT merged. This give me a top cell to display the value and the lower cells to have "Num" "/" "Den".

    The issue is that the "/" and "Den" are not being affected by the conditional formatting. I have attached my sample spreadsheet with everything in place. I tried everything I know, and engaged some excel savvy friends and it's still unresolved.

    Any help here perhaps?
    Attached Files Attached Files
    Last edited by Clemson_Fan; 10-05-2022 at 08:27 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
    24,704

    Re: Conditional Formatting not applying to all cells in range

    Click on cell I5 then on Conditional formatting | Manage Rules and then on Edit rule, and change it to this:

    =$K$1="No"

    Click OK twice to apply that rule. You will need to repeat this for your other conditions (i.e. change =N$1="No" for the cell L5 to =$N$1="No", and so on).

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-05-2022
    Location
    Gastonia, NC
    MS-Off Ver
    365
    Posts
    3

    Re: Conditional Formatting not applying to all cells in range

    Well, I got close to it! That worked great! Thank you! Some things, after you see them, make all the sense in the world.

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

    Re: Conditional Formatting not applying to all cells in range

    Glad to have helped, and thanks for marking the thread as Solved.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  5. #5
    Registered User
    Join Date
    10-05-2022
    Location
    Gastonia, NC
    MS-Off Ver
    365
    Posts
    3

    Re: Conditional Formatting not applying to all cells in range

    Thank you! I think I did it correctly. Again, I appreciate the help.

+ 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 not applying to all req'd cells
    By iCountWater in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2021, 05:02 PM
  2. [SOLVED] Conditional Formatting Only Applying to Part of Specified Range
    By saq7792 in forum Excel General
    Replies: 5
    Last Post: 02-22-2017, 05:37 PM
  3. [SOLVED] Applying Conditional Formatting Formula Across a Range of Cells
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-14-2016, 08:51 AM
  4. [SOLVED] Applying Formats from Conditional Formatting to Other Cells
    By McStagger in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2014, 04:02 PM
  5. [SOLVED] Applying Conditional Formatting to a Range in VBA (range is set by variables)
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-12-2013, 08:32 AM
  6. Looping through cells and applying conditional formatting
    By stroberaver in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2011, 07:17 AM
  7. Replies: 6
    Last Post: 11-22-2006, 02:09 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