Hi All
This is my first post :-)
I have looked at a lot of help online and there seems to be a everything but what I'm looking for! I have an output from a log file with a date & time column (21/04/2020 09:28:18) and what I would like to achieve is to alternate the fill colour of each group of rows between two contrasting shades so that it is obvious to the viewer when the date changes. So the colour change only occurs when the date changes and there is a varying number of entries (rows) for each date.
The closest thing I can get is a formula for finding fractions of a year (is there a day equivalent?), INT is used to get a whole number. The number is then put in a "helper" column and conditional formatting that changes the fill colour of the row is applied based on the "helper" column
I hope I've made myself clear?
Thank you for any help you can give
Bookmarks