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.

Help needed from excel expert
 

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.

Help needed from excel expert
 

Thank you.
"FSt1" wrote in message
...
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.