+ Reply to Thread
Results 1 to 5 of 5

Highlight cell at the start of every month for the first 4 days

  1. 01-10-2017, 01:59 PM #1
    MTC2016
    MTC2016 is offline
    Registered User
    Join Date
    03-28-2016
    Location
    Coventry
    MS-Off Ver
    Microsoft 365
    Posts
    65

    Highlight cell at the start of every month for the first 4 days

    Hi Guys,

    So, I am building a management dashboard which prompts me when items require attention (to keep on top of everything and hopefully, to make me more efficient) As daft as it sounds, I have a monthly management report to complete which I am always being chased for and considering I am going to be using my dashboard for everything else, I thought it would be good to have a prompt on there for the Start of every month.

    I have the =NOW() function/formula at the top of my dashboard which I am thinking I can link to cell AL20 which I can conditionally format to go green for the majority of the moth and red at the start of the month for around the first 3-4 days perhaps just so it acts as a visual reminder.

    I have tried a few things but I'm not getting the result I am after so I thought I would turn to you guys for some guidance.


    Basically In cell AL20 I want the color to change to green for the majority of the month and turn red for the first 4 days of each month then turn green again based on the =NOW() formula which is located in cell S3.

    If you can think of anything which would work better than this then I am all ears provided I get the desired effect or something to that nature
    Reply With QuoteRegister To Reply
  2. 01-10-2017, 02:30 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Highlight cell at the start of every month for the first 4 days

    Hi

    Use the CF 'Use a Formula....' option and enter

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 01-10-2017, 02:34 PM #3
    FDibbins
    FDibbins is offline
    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,936

    Re: Highlight cell at the start of every month for the first 4 days

    I would use TODAY() rather than NOW() (which includes time)

    Then, assuming you have TODAY() in K1, use this as a CF rule...
    =AND(K1>EOMONTH(K1,0),K1<=EOMONTH(K1,0)+4)
    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 With QuoteRegister To Reply
  4. 01-10-2017, 02:34 PM #4
    FDibbins
    FDibbins is offline
    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,936

    Re: Highlight cell at the start of every month for the first 4 days

    I would use TODAY() rather than NOW() (which includes time)

    Then, assuming you have TODAY() in K1, use this as a CF rule...
    =AND(K1>EOMONTH(K1,0),K1<=EOMONTH(K1,0)+4)
    Reply With QuoteRegister To Reply
  5. 01-10-2017, 02:34 PM #5
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Highlight cell at the start of every month for the first 4 days

    turn red for the first 4 days of each month
    Maybe something like this...

    Assume the NOW function is in cell A1.

    =AND(COUNT(A1),DAY(A1)<=4)

    Your other condition is not well defined.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If cell A1 is blank 20 days after 1st of the month, Then highlight cell Blue
    By boyd123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2016, 12:10 PM
  2. Does the date fall within X amount of working days from start of the month
    By pauldaddyadams in forum Excel General
    Replies: 3
    Last Post: 01-15-2016, 10:12 AM
  3. [SOLVED] Counting the number of days per month where where a job start time was after 10:00
    By Apache_sim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-15-2013, 07:59 AM
  4. Highlight & Update cell value on start of each month...
    By z-eighty2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2013, 10:13 PM
  5. Highlight & Update cell value on start of each month...
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 06:29 PM
  6. [SOLVED] Using Conditional Formatting to highlight cells based on days of the month
    By BrutalExcel in forum Excel General
    Replies: 2
    Last Post: 06-06-2013, 01:10 AM
  7. Codes to highlight specified days of the month
    By BrutalExcel in forum Excel General
    Replies: 0
    Last Post: 06-05-2013, 06:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1