=COUNTIF(A$1:A$45,TODAY())>0
I have 52 sheets to represent weeks of the year. The sheet that has the current date should he highlighted as per the the above formula.
I have created a new rule in conditional formatting for about 10 sheets. Is there an easier way to copy this formula to all sheets?
Thanks in advance.
I have 52 sheets to represent weeks of the year. The sheet that has the current date should he highlighted as per the the above formula.
I have created a new rule in conditional formatting for about 10 sheets. Is there an easier way to copy this formula to all sheets?
Thanks in advance.