Conditional Formatting - Dates
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
|