Conditional Formatting change only sheet number

[georgegram]

Hello everyone,

I got a workbook, where i have 31 sheets (one for each day of the month). Then there is a final sheet where i got a column with every day of the month.
When i set a formula in the 1st of the month to read a specific text from the 1st sheet, everything goes ok.
Instead of doing that for every day, is there a way to auto fill the following days by changing only the sheet number?

Sheets are named like: 01,02,03,04...31

The formula i use in conditional formatting is =COUNTIF('01'!$C$19:$AG$19;"*"&$AC$32&"*")>0
All i ask if there is a way to keep everything the same and change the '01' to '02','03' etc.

Thanks in advance,
George

 

[georgegram]

wow i just did it, and it stayed! Thanks a lot , this forum has given me 3 times so far the best solutions from every site around the internet !
i thanked you for every respond :D

 

[etaf]

cool, glad its now resolved for you