What did you try?
What results did you get?
What version of Excel are you using?
What color do you want it changed to?
Is the color different for 21 days than it is for 28 days?

You're not making it easy for people to help when you post ambiguous
questions. It looks like you're asking everyone else to do the work when
you're not willing to do any.

Post back with specifics so people can get you a definitive answer rather
than trying to guess what you want.

Regards,
Fred

"Ray" wrote in message
...
Thanks for the help with the other formulas on my last thread but I still
can't get my "in between" formatting to work. I want the date entered
into
A1 to change color when the computer calendar is 21 to 28 days after the
date
entered. Thanks.