I have a range A1:H53 indicating the weeks of a year. col A is the week number, col B to H are the days of the week (starting monday).
each cell in the range contains the date values (see the example)
I'd want that the value in col a (i.e; the week number) is highlighted if today's date falls within that week.
for example, if today is 22/04/2016, the value "16" in column A should be highlighted
15 11/04/2016 12/04/2016 13/04/2016 14/04/2016 15/04/2016 16/04/2016 17/04/2016
16 18/04/2016 19/04/2016 20/04/2016 21/04/2016 22/04/2016 23/04/2016 24/04/2016
17 25/04/2016 26/04/2016 27/04/2016 28/04/2016 29/04/2016 30/04/2016 1/05/2016
Bookmarks