Dear all,
I have data as attached.
I wish to do the following. All time in after 9:01 is highlighted in red, before 09:00 is green.
For cells with 00:00 it should be in yellow.
However the highlighted area is not only the cells but the adjacent of it as shown.
If weekends could be avoided for formatting i.e. not in any colour that would be better.
Thank you for your help![]()
Bookmarks