Highlighting dates.

  • Thread starter Thread starter robert_woodie
  • Start date Start date
R

robert_woodie

I need a macro which sorts through coloumns of data and if EITHER th
start or finish date is a wknd i need it to highlight the entire row
ie. change the background colour. Say colomns A and B have the star
and finish dates, C has a list of wknd dates.

Im sure its simple, problem is im simple to!!

cheers
Rober
 
One way highlighting weekend dates

select the columns, assuming in this example they are A and B starting in A2
and B2, select both columns,
with A2 as the active cell (if you start selecting from A2 with the mouse it
will be active)
do format>conditional formatting, formula is and use

=WEEKDAY(A2,2)>5

click the format button and select maybe a red back ground, click OK twice
 
Back
Top