RodriguisIUR
Nov 7, 2009, 03:00 PM
Hello,
I would like to format dynamically a column of cells with various colors in function of the day that is it written in the column before.
For instance:
Cells A1:A7 have "Monday;Tuesday;Wednesday;Thrusday;Friday;Saturday; Sunday"
Cells B1:B7 will have what I will write in them but I want that these cells have colors in some specific days, like Saturday and Sunday, or if it is holiday like Christmas.
This will be utilized for a dynamic calendar, changing every year, so I would appreciate any help.
Thanks.
I would like to format dynamically a column of cells with various colors in function of the day that is it written in the column before.
For instance:
Cells A1:A7 have "Monday;Tuesday;Wednesday;Thrusday;Friday;Saturday; Sunday"
Cells B1:B7 will have what I will write in them but I want that these cells have colors in some specific days, like Saturday and Sunday, or if it is holiday like Christmas.
This will be utilized for a dynamic calendar, changing every year, so I would appreciate any help.
Thanks.