+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting: Highlight specific time frame

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Microsoft Office 2007

    Conditional Formatting: Highlight specific time frame


    Is it possible to do conditional formatting to highlight a cell in an array based on a criteria?
    Say for example a series of military time 00:00 - 17:00
    We want to highlight Cells in an array that starts with a time from 12PM - 5PM EST

    Any help on this would be greatly appreciated
    Last edited by dlealb; 02-22-2020 at 05:45 PM.

  2. #2
    Registered User
    Join Date
    Missouri, USA
    MS-Off Ver
    2007 through 2019

    Re: Conditional Formatting: Highlight specific time frame

    Home Tab -> Conditional Formatting -> Highlight Cells Rules -> Between...
    A window opens for you to fill in your parameters and choose your formatting.

+ 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] How to use Conditional Formatting, to find and highlight specific data
    By Deaco in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2019, 10:38 AM
  2. [SOLVED] Conditional Formatting to Highlight specific Cells Annually
    By Bryan.Pagenkopf in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2018, 03:04 PM
  3. Replies: 6
    Last Post: 06-04-2015, 05:15 AM
  4. Conditional Formatting from a different sheet to highlight specific ranges
    By Bengymivec in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-24-2015, 11:29 AM
  5. Replies: 3
    Last Post: 02-26-2014, 12:10 AM
  6. Replies: 3
    Last Post: 08-02-2013, 12:43 PM
  7. [SOLVED] Conditional formatting, highlight multiple of a specific number
    By Mihail-Cosmin in forum Excel General
    Replies: 11
    Last Post: 03-21-2012, 12:16 PM


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