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

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" wrote:

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

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

"Mike H" wrote:

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" wrote:

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