I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance

Say Column A contains the dates and B contains the conditional formatting.

In B1 enter this formula
=IF(TODAY()-A1<7,"Processing",IF(TODAY()-A1<14,"Check Status","Over Due"))

copy down as needed
select column B and select Format-conditional formatting
Select "Cell Value Is" and "Equal to" and enter
="Processing"
change the format to a green background color
Select Add and do the same (except choose different colors) for
="Check Status"
and
="Over Due"

click okay


"SR7133" wrote:

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance

Thank you very much for that - I have done as you say but there are a couple
of points which I cannot resolve:
1. The "over 14days" is not turning the cell red
2. Column B shows "Overdue" in all the cells when there are no dates in
Column A

Can you advise how to resolve this please?

"Sloth" wrote:

Say Column A contains the dates and B contains the conditional formatting.

In B1 enter this formula
=IF(TODAY()-A1<7,"Processing",IF(TODAY()-A1<14,"Check Status","Over Due"))

copy down as needed
select column B and select Format-conditional formatting
Select "Cell Value Is" and "Equal to" and enter
="Processing"
change the format to a green background color
Select Add and do the same (except choose different colors) for
="Check Status"
and
="Over Due"

click okay


"SR7133" wrote:

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance

1. Check that the output of the cell and the conditional format condition
are the same. I accidently made overdue two words "over due". This might be
where your error came from.

2. Change your formula to
=IF(A1=0,"",IF(TODAY()-A1<7,"Processing",IF(TODAY()-A1<14,"Check
Status","Overdue")))

"SR7133" wrote:

Thank you very much for that - I have done as you say but there are a couple
of points which I cannot resolve:
1. The "over 14days" is not turning the cell red
2. Column B shows "Overdue" in all the cells when there are no dates in
Column A

Can you advise how to resolve this please?

"Sloth" wrote:

Say Column A contains the dates and B contains the conditional formatting.

In B1 enter this formula
=IF(TODAY()-A1<7,"Processing",IF(TODAY()-A1<14,"Check Status","Over Due"))

copy down as needed
select column B and select Format-conditional formatting
Select "Cell Value Is" and "Equal to" and enter
="Processing"
change the format to a green background color
Select Add and do the same (except choose different colors) for
="Check Status"
and
="Over Due"

click okay


"SR7133" wrote:

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance

Dear Sloth

That did the trick - thank you very much for your assistance - much
appreciated

"SR7133" wrote:

Thank you very much for that - I have done as you say but there are a couple
of points which I cannot resolve:
1. The "over 14days" is not turning the cell red
2. Column B shows "Overdue" in all the cells when there are no dates in
Column A

Can you advise how to resolve this please?

"Sloth" wrote:

Say Column A contains the dates and B contains the conditional formatting.

In B1 enter this formula
=IF(TODAY()-A1<7,"Processing",IF(TODAY()-A1<14,"Check Status","Over Due"))

copy down as needed
select column B and select Format-conditional formatting
Select "Cell Value Is" and "Equal to" and enter
="Processing"
change the format to a green background color
Select Add and do the same (except choose different colors) for
="Check Status"
and
="Over Due"

click okay


"SR7133" wrote:

I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following:

I will be entering dates in a column and then between 1 and 7 days an
adjacent cell will show green and the words "Processing"

Between 8 days and 14 days the adjacent cell should turn yellow and show
"Check Status"

If the period exceeds 14days then the cell should turn red and show the word
"Overdue"

I have tried a number of the responses in the threads but just cannot seem
to get the proper result.

Thanks in advance