+ Reply to Thread
Results 1 to 4 of 4

Excel 2016: Conditional Formatting to highlight weekends

  1. #1
    Registered User
    Join Date
    01-23-2016
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Office 2016
    Posts
    36

    Excel 2016: Conditional Formatting to highlight weekends

    Dear Excel Forum members,

    I'm using Excel 2016 but can't get the conditional formatting to work the way I expect it to.

    I am trying to create an Employee Leave Tracker. The plan is to create one month and then use that as a template for the other 11 months of the year. I will then link that data back to a summary sheet. I've made a basic calendar, but wanted to use conditional formatting to highlight the weekends (which for us is Friday and Saturday). I used the formula:

    =WEEKDAY($B1, 1)>5

    and asked for the arguments that are true, to turn Green. But pretty much everything in my query turned green!!! I'm sure this is user error but clueless as to where I am going wrong. I've attached my spreadsheet to show you.

    Hoping someone can help me as I feel like I've searched the internet and come up with nothing!!!

    Open to any and all feedback.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    Re: Excel 2016: Conditional Formatting to highlight weekends

    Very close....

    =WEEKDAY(B$1, 2)>5

  3. #3
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Excel 2016: Conditional Formatting to highlight weekends

    You got to put "$" before 1 like this-

    Please Login or Register  to view this content.
    5

    This is because row is fixed as 1 not the column B.
    Cheers!!
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  4. #4
    Registered User
    Join Date
    01-23-2016
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Office 2016
    Posts
    36

    Re: Excel 2016: Conditional Formatting to highlight weekends

    Thank you! A MILLION TIMES! I was pretty close, just not close enough

    This worked perfectly.

+ 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: 9
    Last Post: 12-17-2015, 10:44 AM
  2. Conditional formatting for weekends
    By Lukael in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2014, 10:50 AM
  3. conditional formatting for weekends
    By Lukael in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-24-2014, 05:35 PM
  4. Conditional Formatting Around Weekends
    By robatbrightstar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2013, 02:43 PM
  5. Conditional Formatting to exclude weekends
    By slantin in forum Excel General
    Replies: 6
    Last Post: 08-13-2013, 11:27 AM
  6. Conditional Formatting weekends
    By IKZOUHETNIETWETEN in forum Excel General
    Replies: 7
    Last Post: 02-22-2013, 01:58 AM
  7. Conditional formatting for weekends
    By monozoli in forum Excel General
    Replies: 2
    Last Post: 04-13-2008, 01:44 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