Conditional Formatting - Dates

[nbslarson]

I need to set conditional formatting to change the color on cells which are
NOT either 06 or 21 in the date format.
Column is
10/06/09
10/21/09
11/06/09
11/20/09
12/04/09
12/21/09

01/06/10
01/21/10
02/05/10
02/19/10
03/05/10
03/19/10

04/06/10
04/21/10
05/06/10
05/21/10
06/04/10
06/21/10

 

[Mike H]

Hi,

Select this column of dates then
Format|Conditional format - formula is - enter the formula
=AND(DAY(A1)<>6,DAY(A1)<>21)
Pick a colour - OK

Change A1 in the formula to the addtess of the topmost selected cell.

Mike

 

[nbslarson]

Thank you, thank you, thank you! You are wonderful!!!