+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting for Today and Tomorrow

  1. #1
    Forum Contributor
    Join Date
    02-12-2014
    Location
    al ain
    MS-Off Ver
    Excel 2016
    Posts
    149

    Cool Conditional formatting for Today and Tomorrow

    Hi All,
    The formulas below are working perfect for conditional formatting
    Format is Yellow if the date is Today =$B2=TODAY()
    Format is Green if the date is Tomorrow =$B2=TODAY()+1
    Here I want to skip the weekend 2 days if happening before working day. And I want the same green format as for tomorrow.
    e.g. If today is last day of week, then I want the upcoming working day cell format green same as for tomorrow.
    Attached Files Attached Files
    Last edited by alipezu; 01-24-2017 at 01:45 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Conditional formatting for Today and Tomorrow

    Try something like this...
    =AND($B2=TODAY()+1,WEEKDAY($B2,2)<6)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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: 10
    Last Post: 09-06-2023, 08:19 PM
  2. [SOLVED] Count "ONLY" dates (Today/Tomorrow in filtered view viisable)
    By MBCMDR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2015, 02:27 PM
  3. [SOLVED] Make TODAY() not change tomorrow?
    By CSPENCER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2015, 06:54 PM
  4. [SOLVED] Automatically filling date of today (without it changing tomorrow)
    By Jaydubs in forum Excel General
    Replies: 6
    Last Post: 09-29-2014, 12:35 PM
  5. [SOLVED] Conditional Formatting for TODAY
    By tapsmiled in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-25-2014, 09:18 PM
  6. Conditional Formatting help with =Today()
    By Prosatinos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2013, 06:56 AM
  7. [SOLVED] Conditional Formatting ... Today() & More
    By Ken in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 11:06 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