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.
>>
>>
>>