Help needed from excel expert

Hello,
I want to create a spreadsheet listing bills and due dates. I would like
column (A) to have the name of the bill and column (C) the have the due
date.
When the due date is a week away I would like the cell in column (A) to
change colors. I know I should use conditional formatting for this but I
need help with the formula to calculate the seven days within the due date.

hi,
condition 1
if cell value is - less than or equal to - =today()
format = red
condition 2
if cell value is - less than or equal to - =today() +7
format = yellow

any date within 7 day for the due date will be yellow
any date that is today or overdue will be red.

regards
FSt1

"Digital2k" wrote:

> Hello,
> I want to create a spreadsheet listing bills and due dates. I would like
> column (A) to have the name of the bill and column (C) the have the due
> date.
> When the due date is a week away I would like the cell in column (A) to
> change colors. I know I should use conditional formatting for this but I
> need help with the formula to calculate the seven days within the due date.
>
>
>

Thank you.
"FSt1" <FSt1@discussions.microsoft.com> wrote in message
news:DBA08A57-ACB8-44BC-8D81-C4AD86F36716@microsoft.com...
> hi,
> condition 1
> if cell value is - less than or equal to - =today()
> format = red
> condition 2
> if cell value is - less than or equal to - =today() +7
> format = yellow
>
> any date within 7 day for the due date will be yellow
> any date that is today or overdue will be red.
>
> regards
> FSt1
>
> "Digital2k" wrote:
>
>> Hello,
>> I want to create a spreadsheet listing bills and due dates. I would like
>> column (A) to have the name of the bill and column (C) the have the due
>> date.
>> When the due date is a week away I would like the cell in column (A) to
>> change colors. I know I should use conditional formatting for this but I
>> need help with the formula to calculate the seven days within the due
>> date.
>>
>>
>>