color coding

[Guest]

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.

 

[PCLIVE]

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

 

[Guest]

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