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.
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
Many thanks
ive just tried it and it works perfect!