Hello,
I'm looking for a macro to change the format of an entire column to a different shade if it is a Sunday only.
The date ranges run from G2:IV2
I'm using weekday() function to show the serial number of that date. If those dates are "sundays" or 1, I would like for the macro to shade the entire column grey and possibly add borders to the left/right of that column.
I'm looking for a macro to change the format of an entire column to a different shade if it is a Sunday only.
The date ranges run from G2:IV2
I'm using weekday() function to show the serial number of that date. If those dates are "sundays" or 1, I would like for the macro to shade the entire column grey and possibly add borders to the left/right of that column.
