how do I colour cells or conditionally format a range of cells based on a start date/time and end date/time?
how do I colour cells or conditionally format a range of cells based on a start date/time and end date/time?
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
Not difficult... but not easy without a sample to play with. Please read the yellow banner (top) and post a sample sheet, showing (manually) your desired result.
Glenn
Administrative Note:
In your other thread that was asking essentially the same thing, I asked you to wait patiently for assistance.
Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #5 about thread duplication.
I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-cha...time-help.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks