Conditional formatting with dates..

A

Arjan

Hi All,

Does anybody knows how I can do a conditional format on dates?

i.e. I would like to change the textcolour for every date between 01-xx-xxxx
and 15-xx-xxxx
where the xx stands for every months and the xxxx for every years...

Does anybody have any idea?
thanks in advance!!

Best regards,

Arjan Bregman
the Netherlands
 
A

Arjan

Hi Doug,

I'm sorry but I do not understand what you mean.. :(
Could you please clarify it a little bit more?

thnx!

Arjan
 
D

Douglas J. Steele

I can't actually test, because I only have Access 97 installed at the
moment, but where you're setting the condition, based it on
Day([MyDateField]). If that's less than 16, make it colour 1, otherwise make
it colour 2.
 
Top