CONDITIONAL FORMATTING (WEEKENDS) - HOW TO CONTINUE ON THE NEXT COLUMNS

[Tassos Spyrellis]

DEAR ALL,

IN MY DATA BASE I HAVE COLUMN A AS THE DATE AND I HAVE ALREADY USED CONDITIONAL FORMATING FOR THE DATES IN ORDER TO HIGHLIGHT THE WEEKENDS, NOW I WANT THE SAME FORMATTING TO BE CONTINUED ON A NUMBER OF COLUMS ADJACENT TO COLUMN A I.E COLUMS B,C,D,E - ETC.

[Excel Fox]

In the conditional format used for your first column, just ensure that you have referenced the column A in absolute terms and then just copy the format across to adjacent columns.

So for example, if your conditional format is =WEEKDAY(A1,2)>5, then just change it to =WEEKDAY($A1,2)>5

[Tassos Spyrellis]

Many thanks

ive just tried it and it works perfect!