Hi, I need help coloring for the week.
In the attached file I would like to be able to color line 10 as line 16,
by week and, changing the month, they adapt to the week
Thank you
Hi, I need help coloring for the week.
In the attached file I would like to be able to color line 10 as line 16,
by week and, changing the month, they adapt to the week
Thank you
This is a bit tricky, as I am not entirely clear how you want it to look, but you can use this in C17 drag copied across to calculate the week number:
=WEEKNUM($C$2+COLUMNS($C17:C17)-1,2)
You will need rules for each of the colours:
=C17=$C17
=C17=$C17+1
=C17=$C17+2
=C17=$C17+3
=C17=$C17+4
=C17=$C17+5
Last edited by AliGW; 02-15-2020 at 05:53 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
fast and perfect as always
Thank you
Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks