how to highlight holidays and weekend by conditional format in excel

[vinayvanam]

how to highlight Holidays & Week ends by conditional format

Date	Holidays	Week ends
08/01/2014	08/05/2014	08/02/2014
08/02/2014	08/15/2014	08/03/2014
08/03/2014	08/29/2014	08/09/2014
08/04/2014		08/10/2014
08/05/2014		08/16/2014
08/06/2014		08/17/2014
08/07/2014		08/23/2014
08/08/2014		08/24/2014
08/09/2014
08/10/2014
08/11/2014
08/12/2014
08/13/2014
8/14/2014
08/15/2014
08/16/2014
08/17/2014
08/18/2014
08/19/2014
08/20/2014
08/21/2014
08/22/2014
08/23/2014
08/24/2014
08/25/2014
08/26/2014
08/27/2014
08/28/2014
08/29/2014

<tbody>
</tbody>

 

[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