I would like to have a close out date entered then when entered

If the date is 30 days or more from the current date the closeout
block becomes red behind the date
If the date is 90 days or more from the current date the closeout
block becomes Yellow behind the date
If the date is before the current date the closeout block becomes
Green behind the date
Also would like the spreadsheet to sort the rows based on the color of
the block and then by alphabetical

Red = Within 30 days AFTER C/O
Yellow = Within 90 days BEFORE C/O
Green = Current

Thanks

Chris

On Jul 6, 10:17 am, "belc...@gmail.com" <belc...@gmail.com> wrote:
> I would like to have a close out date entered then when entered
>
> If the date is 30 days or more from the current date the closeout
> block becomes red behind the date
> If the date is 90 days or more from the current date the closeout
> block becomes Yellow behind the date
> If the date is before the current date the closeout block becomes
> Green behind the date
> Also would like the spreadsheet to sort the rows based on the color of
> the block and then by alphabetical
>
> Red = Within 30 days AFTER C/O
> Yellow = Within 90 days BEFORE C/O
> Green = Current
>
> Thanks
>
> Chris

Chris,

Search the Excel Help for Conditional Formatting. Conditional
Formatting will allow you to input up to 3 conditions will
accompanying formats. If you want more than 3 conditions, then you'll
need to write a small macro for that.

Matt

see response in public.excel

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I would like to have a close out date entered then when entered
>
> If the date is 30 days or more from the current date the closeout
> block becomes red behind the date
> If the date is 90 days or more from the current date the closeout
> block becomes Yellow behind the date
> If the date is before the current date the closeout block becomes
> Green behind the date
> Also would like the spreadsheet to sort the rows based on the color of
> the block and then by alphabetical
>
> Red = Within 30 days AFTER C/O
> Yellow = Within 90 days BEFORE C/O
> Green = Current
>
> Thanks
>
> Chris
>