ExcelBanter - Conditional Formatting Weekends

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formatting Weekends (https://www.excelbanter.com/excel-worksheet-functions/133935-conditional-formatting-weekends.html)

TamIam

Conditional Formatting Weekends

Is it possible to apply a conditional format to weekend dates? For example,
my spreadsheet has been filled in with the date format showing the days
"Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a
conditional format, but I cannot seem to get it working.

--
Thanks for your help!

Mike

Conditional Formatting Weekends

Use this for A1 and paint it in for other cells that have dates you want this
format for

Conditional formatting - formula is
=WEEKDAY(A1,2)5
select a colour

Mike

"TamIam" wrote:

Is it possible to apply a conditional format to weekend dates? For example,
my spreadsheet has been filled in with the date format showing the days
"Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a
conditional format, but I cannot seem to get it working.

--
Thanks for your help!

TamIam

Conditional Formatting Weekends

Wonderful!! Many thanks Mike!

--
Thanks for your help!

"Mike" wrote:

Use this for A1 and paint it in for other cells that have dates you want this
format for

Conditional formatting - formula is
=WEEKDAY(A1,2)5
select a colour

Mike

"TamIam" wrote:

Is it possible to apply a conditional format to weekend dates? For example,
my spreadsheet has been filled in with the date format showing the days
"Thu-Mar-8-07", and when it contains "Sat" or "Sun" I would like a
conditional format, but I cannot seem to get it working.

--
Thanks for your help!

All times are GMT +1. The time now is 08:20 AM.