View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nbslarson nbslarson is offline
external usenet poster
 
Posts: 16
Default Conditional Formatting - Dates

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