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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Deaco in forum Excel Formulas & Functions
Last Post: 07-24-2019, 10:38 AM
By Bryan.Pagenkopf in forum Excel Formulas & Functions
Last Post: 09-10-2018, 03:04 PM
By Travissaw in forum Excel General
Last Post: 06-04-2015, 05:15 AM
By Bengymivec in forum Excel - New Users/Basics
Last Post: 01-24-2015, 11:29 AM
By sunjam in forum Excel General
Last Post: 02-26-2014, 12:10 AM
By PaulKMc in forum Excel - New Users/Basics
Last Post: 08-02-2013, 12:43 PM
By Mihail-Cosmin in forum Excel General
Last Post: 03-21-2012, 12:16 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1