ExcelBanter - Conditional format weekend

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional format weekend (https://www.excelbanter.com/excel-discussion-misc-queries/213611-conditional-format-weekend.html)

Mortir

Conditional format weekend

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

Lars-Åke Aspelin[_2_]

Conditional format weekend

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

Mortir

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!

All times are GMT +1. The time now is 12:38 AM.