Conditional format> weekend

M

Mortir

id like to color saturdays and sundays with different color then my
workdays. Is it possible to do this using conditional format? And how?
 
L

Lars-Åke Aspelin

id like to color saturdays and sundays with different color then my
workdays. Is it possible to do this using conditional format? And how?
Click to expand...


If A1:A100 is the range where your dates are, try the following as
formula within Conditional Formatting:

=(WEEKDAY(A1:A100,2)>5)

Hope this helps / Lars-Åke
 
M

Mortir

If A1:A100 is the range where your dates are, try the following as
formula within Conditional Formatting:

=(WEEKDAY(A1:A100,2)>5)

Hope this helps / Lars-Åke
Click to expand...

great, many tnx!
 
Top