Conditional format weekend
On 14 dec., 13:50, Lars-Åke Aspelin wrote:
On Sun, 14 Dec 2008 04:32:43 -0800 (PST), Mortir
wrote:
id like to color saturdays and sundays with different color then my
workdays. Is it possible to do this using conditional format? And how?
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
great, many tnx!
|