Conditional format> weekend

  • Thread starter Thread starter Mortir
  • Start date Start date
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?
 
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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format 2
Excel Macro to automatically go to the right of the last colored cell 0
how do i force an value to "jump over weekends" 5
Saturday Sunday 1
Conditionally setting background color of a cell 1
Date + X days excluding holidays 1
Friday as weekend in Workday Function 6
Conditional formating 3

Back
Top