+ Reply to Thread
Results 1 to 3 of 3

If date is falls on Saturday then said conditional formatting to be applied based on time

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    52

    If date is falls on Saturday then said conditional formatting to be applied based on time

    Hi There,

    > If particular day is Saturday, then following condition format to be applied in cell on timing.
    > I have applied the default condition formatting formula for Monday to Friday, for Saturday there is difference entry time, but I am not sure how to apply the same for Saturday
    > The entry times are in the format hh:mm:ss, I want the cell to have a different font colour if it falls in particular time frames based on the below if it is Saturday”.

    Example:
    If the person entry time is by or before 09:30:00 Font given in Green colour
    If the person entry between 09:30:01 to 09:45:00 Font colour given in pink
    if the person entries after 09:45.01 to 10:00:00, font colour given in Red colour
    if the person entries after 10:00:00, then background colour highlighted with red

    Sample spreadsheet is attached.

    Thanks... Senthil
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    18,529

    Re: If date is falls on Saturday then said conditional formatting to be applied based on t

    For Green

    CF rule

    Use a formula ....

    =AND(WEEKDAY(D$2,2)=6,D4<>"",D4<=TIME(9,30,0))

    Similar formula for other conditions

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    India
    MS-Off Ver
    Excel 2019
    Posts
    52

    Re: If date is falls on Saturday then said conditional formatting to be applied based on t

    Hi John Topley,

    Thanks for response. it is working, but how do i assign the conditional formula for the below timing for Saturday.
    If the person entry between 09:30:01 to 09:45:00 Font colour in pink
    if the person entries after 09:45.01 to 10:00:00, font colour in Red colour

    Thanks...Senthil

+ 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] Conditional formatting based on date and time
    By Jalex5134 in forum Excel General
    Replies: 6
    Last Post: 10-26-2017, 05:55 PM
  2. Replies: 0
    Last Post: 06-15-2017, 06:28 PM
  3. Conditional Formatting time with a range applied
    By andyp24 in forum Excel General
    Replies: 7
    Last Post: 07-20-2016, 03:51 AM
  4. [SOLVED] Conditional Formatting of Cells based off of date and time criteria
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-16-2015, 03:14 PM
  5. [Solved] Conditional Formatting based on date and time
    By HackerJL in forum Excel General
    Replies: 5
    Last Post: 06-08-2011, 06:58 PM
  6. [SOLVED] can conditional formatting be applied in more then three instance
    By Mary jane in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-21-2005, 12:10 AM
  7. [SOLVED] Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-19-2005, 08:15 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