Hi, I am using Excel 365. I have the following formula to conditionally format a fill into a column when condition met =OR(WEEKDAY(A2)=1,WEEKDAY(A2)=7) - if the date is a weekend highlight the column. Is there any way to do the whole sheet rather than column by column. So if any date between A2 and BJ2 = a weekend day then fill the corresponding column? Thanks in advance for any help.