software

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 quot;Processingquot;

Between 8 days and 14 days the adjacent cell should turn yellow and show
quot;Check Statusquot;

If the period exceeds 14days then the cell should turn red and show the word
quot;Overduequot;

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()-A1lt;7,quot;Processingquot;,IF(TODAY()-A1lt;14,quot;Check Statusquot;,quot;Over Duequot;))

copy down as needed
select column B and select Format-gt;conditional formatting
Select quot;Cell Value Isquot; and quot;Equal toquot; and enter
=quot;Processingquot;
change the format to a green background color
Select Add and do the same (except choose different colors) for
=quot;Check Statusquot;
and
=quot;Over Duequot;

click okayquot;SR7133quot; wrote:

gt; I have a spreadsheet and am looking for some assistance to make a conditional
gt; format to produce the following:
gt;
gt; I will be entering dates in a column and then between 1 and 7 days an
gt; adjacent cell will show green and the words quot;Processingquot;
gt;
gt; Between 8 days and 14 days the adjacent cell should turn yellow and show
gt; quot;Check Statusquot;
gt;
gt; If the period exceeds 14days then the cell should turn red and show the word
gt; quot;Overduequot;
gt;
gt; I have tried a number of the responses in the threads but just cannot seem
gt; to get the proper result.
gt;
gt; 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 quot;over 14daysquot; is not turning the cell red
2. Column B shows quot;Overduequot; in all the cells when there are no dates in
Column A

Can you advise how to resolve this please?

quot;Slothquot; wrote:

gt; Say Column A contains the dates and B contains the conditional formatting.
gt;
gt; In B1 enter this formula
gt; =IF(TODAY()-A1lt;7,quot;Processingquot;,IF(TODAY()-A1lt;14,quot;Check Statusquot;,quot;Over Duequot;))
gt;
gt; copy down as needed
gt; select column B and select Format-gt;conditional formatting
gt; Select quot;Cell Value Isquot; and quot;Equal toquot; and enter
gt; =quot;Processingquot;
gt; change the format to a green background color
gt; Select Add and do the same (except choose different colors) for
gt; =quot;Check Statusquot;
gt; and
gt; =quot;Over Duequot;
gt;
gt; click okay
gt;
gt;
gt; quot;SR7133quot; wrote:
gt;
gt; gt; I have a spreadsheet and am looking for some assistance to make a conditional
gt; gt; format to produce the following:
gt; gt;
gt; gt; I will be entering dates in a column and then between 1 and 7 days an
gt; gt; adjacent cell will show green and the words quot;Processingquot;
gt; gt;
gt; gt; Between 8 days and 14 days the adjacent cell should turn yellow and show
gt; gt; quot;Check Statusquot;
gt; gt;
gt; gt; If the period exceeds 14days then the cell should turn red and show the word
gt; gt; quot;Overduequot;
gt; gt;
gt; gt; I have tried a number of the responses in the threads but just cannot seem
gt; gt; to get the proper result.
gt; gt;
gt; gt; 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 quot;over duequot;. This might be
where your error came from.

2. Change your formula to
=IF(A1=0,quot;quot;,IF(TODAY()-A1lt;7,quot;Processingquot;,IF(TODAY()-A1lt;14,quot;Check
Statusquot;,quot;Overduequot;)))

quot;SR7133quot; wrote:

gt; Thank you very much for that - I have done as you say but there are a couple
gt; of points which I cannot resolve:
gt; 1. The quot;over 14daysquot; is not turning the cell red
gt; 2. Column B shows quot;Overduequot; in all the cells when there are no dates in
gt; Column A
gt;
gt; Can you advise how to resolve this please?
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; Say Column A contains the dates and B contains the conditional formatting.
gt; gt;
gt; gt; In B1 enter this formula
gt; gt; =IF(TODAY()-A1lt;7,quot;Processingquot;,IF(TODAY()-A1lt;14,quot;Check Statusquot;,quot;Over Duequot;))
gt; gt;
gt; gt; copy down as needed
gt; gt; select column B and select Format-gt;conditional formatting
gt; gt; Select quot;Cell Value Isquot; and quot;Equal toquot; and enter
gt; gt; =quot;Processingquot;
gt; gt; change the format to a green background color
gt; gt; Select Add and do the same (except choose different colors) for
gt; gt; =quot;Check Statusquot;
gt; gt; and
gt; gt; =quot;Over Duequot;
gt; gt;
gt; gt; click okay
gt; gt;
gt; gt;
gt; gt; quot;SR7133quot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet and am looking for some assistance to make a conditional
gt; gt; gt; format to produce the following:
gt; gt; gt;
gt; gt; gt; I will be entering dates in a column and then between 1 and 7 days an
gt; gt; gt; adjacent cell will show green and the words quot;Processingquot;
gt; gt; gt;
gt; gt; gt; Between 8 days and 14 days the adjacent cell should turn yellow and show
gt; gt; gt; quot;Check Statusquot;
gt; gt; gt;
gt; gt; gt; If the period exceeds 14days then the cell should turn red and show the word
gt; gt; gt; quot;Overduequot;
gt; gt; gt;
gt; gt; gt; I have tried a number of the responses in the threads but just cannot seem
gt; gt; gt; to get the proper result.
gt; gt; gt;
gt; gt; gt; Thanks in advance

Dear Sloth

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

quot;SR7133quot; wrote:

gt; Thank you very much for that - I have done as you say but there are a couple
gt; of points which I cannot resolve:
gt; 1. The quot;over 14daysquot; is not turning the cell red
gt; 2. Column B shows quot;Overduequot; in all the cells when there are no dates in
gt; Column A
gt;
gt; Can you advise how to resolve this please?
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; Say Column A contains the dates and B contains the conditional formatting.
gt; gt;
gt; gt; In B1 enter this formula
gt; gt; =IF(TODAY()-A1lt;7,quot;Processingquot;,IF(TODAY()-A1lt;14,quot;Check Statusquot;,quot;Over Duequot;))
gt; gt;
gt; gt; copy down as needed
gt; gt; select column B and select Format-gt;conditional formatting
gt; gt; Select quot;Cell Value Isquot; and quot;Equal toquot; and enter
gt; gt; =quot;Processingquot;
gt; gt; change the format to a green background color
gt; gt; Select Add and do the same (except choose different colors) for
gt; gt; =quot;Check Statusquot;
gt; gt; and
gt; gt; =quot;Over Duequot;
gt; gt;
gt; gt; click okay
gt; gt;
gt; gt;
gt; gt; quot;SR7133quot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet and am looking for some assistance to make a conditional
gt; gt; gt; format to produce the following:
gt; gt; gt;
gt; gt; gt; I will be entering dates in a column and then between 1 and 7 days an
gt; gt; gt; adjacent cell will show green and the words quot;Processingquot;
gt; gt; gt;
gt; gt; gt; Between 8 days and 14 days the adjacent cell should turn yellow and show
gt; gt; gt; quot;Check Statusquot;
gt; gt; gt;
gt; gt; gt; If the period exceeds 14days then the cell should turn red and show the word
gt; gt; gt; quot;Overduequot;
gt; gt; gt;
gt; gt; gt; I have tried a number of the responses in the threads but just cannot seem
gt; gt; gt; to get the proper result.
gt; gt; gt;
gt; gt; gt; Thanks in advance