Hello everyone, I need your assistance. I have a very large workbook with worksheets corresponding to every day of the month. In each worksheet cell S1 contains a formulated date that evolves from the first day on by adding +1, +2, +3, +30 and so on ....... (I also have other worksheets but they don't have date, they contain charts).
I am wondering if it is possible to detect the date in cell S1 for each sheet, and if it is Sunday, then turn the tab color to red.
Thank you in advance.
Bookmarks