how to highlight holidays and weekend by conditional format in excel

[vinayvanam]

how to highlight Holidays & Week ends by conditional format
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Date[/TD]
[TD="align: center"]Holidays[/TD]
[TD]Week ends[/TD]
[/TR]
[TR]
[TD]08/01/2014[/TD]
[TD]08/05/2014[/TD]
[TD]08/02/2014[/TD]
[/TR]
[TR]
[TD]08/02/2014[/TD]
[TD]08/15/2014[/TD]
[TD]08/03/2014[/TD]
[/TR]
[TR]
[TD]08/03/2014[/TD]
[TD]08/29/2014[/TD]
[TD]08/09/2014[/TD]
[/TR]
[TR]
[TD]08/04/2014[/TD]
[TD][/TD]
[TD]08/10/2014[/TD]
[/TR]
[TR]
[TD]08/05/2014[/TD]
[TD][/TD]
[TD]08/16/2014[/TD]
[/TR]
[TR]
[TD]08/06/2014[/TD]
[TD][/TD]
[TD]08/17/2014[/TD]
[/TR]
[TR]
[TD]08/07/2014[/TD]
[TD][/TD]
[TD]08/23/2014[/TD]
[/TR]
[TR]
[TD]08/08/2014[/TD]
[TD][/TD]
[TD]08/24/2014[/TD]
[/TR]
[TR]
[TD]08/09/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/10/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/11/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/12/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/13/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8/14/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/15/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/16/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/17/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/18/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/19/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/20/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/21/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/22/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/23/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/24/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/25/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/26/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/27/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/28/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08/29/2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Select A1

Conditional Formatting
New Rule
Use a formula to determine...

You need two rules for each cell in column A

=NOT(ISNA(MATCH(A1,B$1:B$3,0)))
format as required for Holidays

=NOT(ISNA(MATCH(A1,C$1:C$8,0)))
format as required for week ends

Use Format painter to copy to other cells

Update: For weekends you can use the WEEKDAY formula to determine Sat/Sun