+ Reply to Thread
Results 1 to 8 of 8

Conditional Formatting to highlight cells relative to date ranges

  1. #1
    Registered User
    Join Date
    06-07-2022
    Location
    Sydney Australia
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Conditional Formatting to highlight cells relative to date ranges

    I want to know how to get the conditional formatting to highlight a cell if it is equal to 1 year but less than 5 years, which i have managed to work out but when I want it to do it again for between 5 and 10, 10 and 15 and so on it stops working.

    Can someone help me with this?
    Last edited by Crazybitch; 06-07-2022 at 10:34 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,987

    Re: Conditional Formatting doing my head in. HELP

    "It" is what? Just a number... or something else??
    Glenn



  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: Conditional Formatting to highlight cells relative to date ranges

    Administrative Note:

    Welcome to the forum.

    Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  4. #4
    Registered User
    Join Date
    06-07-2022
    Location
    Sydney Australia
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Conditional Formatting to highlight cells relative to date ranges

    I've put in an attachment with the conditional formatting that I want it to do and you can see that the formatting is not working
    Attached Files Attached Files

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,020

    Re: Conditional Formatting to highlight cells relative to date ranges

    Hi @Crazybitch
    Do only one item, the others and so on, you have to do it like the picture
    Attached Images Attached Images

  6. #6
    Registered User
    Join Date
    06-07-2022
    Location
    Sydney Australia
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Re: Conditional Formatting to highlight cells relative to date ranges

    Thanks AliGW, I've never been on here before so don't really know the adequate.

  7. #7
    Registered User
    Join Date
    06-07-2022
    Location
    Sydney Australia
    MS-Off Ver
    Microsoft 365
    Posts
    4

    Thumbs up Re: Conditional Formatting to highlight cells relative to date ranges

    Thanks WK9128 you have fixed my problem, you're the best

  8. #8
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,020

    Re: Conditional Formatting to highlight cells relative to date ranges

    @Crazybitch You're Welcome. Glad to help . Thank You for the feedback and rep.


    If you finally get a solution please mark your thread as SOLVED:
    - Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
    - Please click on the *Add Reputation button at the bottom left. Whoever helps you, give it to whoever you like

+ 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] Sports League Head to Head Tie Breaker causing circular references
    By GHURST2 in forum Excel General
    Replies: 4
    Last Post: 06-05-2021, 11:37 AM
  2. [SOLVED] Conditional formatting? if 3 teams head to head? Need highlight it
    By micope21 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2016, 04:55 AM
  3. League Table Based on Head to Head results
    By darkblueblood in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2014, 01:24 PM
  4. How to account for head to head matchup in Excel with other tie breakers
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 05:18 PM
  5. Formatting Chart (My Head Hurts)
    By KCKuhns92 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-20-2013, 11:35 AM
  6. Calculate average of last two outcomes of last two head-to-head clashes
    By wishkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 08:17 AM
  7. Ranking a league table by head to head results
    By pajc72 in forum Excel General
    Replies: 1
    Last Post: 09-02-2011, 07:02 AM

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