color coding
 

I have a spreadsheet that contains parts and due dates. I would like to have
all of the parts that are due today or within the next 45 days to have their
dats a color that I chocs in conditional formatting My problem is that I
don't know how to write it so that today's date and the next 45 days color
coded.

color coding
 

In conditional formatting, choose the option for "Cell Value Is", "between".
Then use:

=TODAY()
in the first box, and:

=TODAY()+45
in the second box.


HTH,
Paul


"Chris" wrote in message
...
I have a spreadsheet that contains parts and due dates. I would like to
have
all of the parts that are due today or within the next 45 days to have
their
dats a color that I chocs in conditional formatting My problem is that I
don't know how to write it so that today's date and the next 45 days
color
coded.

color coding
 

Nevermind. I got it but thatnks for looking at my post

"Chris" wrote:

I have a spreadsheet that contains parts and due dates. I would like to have
all of the parts that are due today or within the next 45 days to have their
dats a color that I chocs in conditional formatting My problem is that I
don't know how to write it so that today's date and the next 45 days color
coded.