I'm trying to create a spreadsheat that will keep track of when our patients
are due for supplies. For example, they can get a certain supply every 6
months. I want the date to turn yellow when we are at the 5 month mark and
red at 6 months
I have a date in cell C2 and have a formula in C3
=C2+180

Assuming you 150 days = 5 months.
On whatever cell you want to change colors, Go to Format, conditional
formatting.
Change first box to "Formula is"
Type
=TODAY()C2+180
go to format, pattern, select red.
Add another condition
formula is
=TODAY()C2+150
format, pattern, select yellow

Note that these formulas are exclusive (C2+150 days exactly is not yellow).
If you want them to be inclusive, change comparisons to "="
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lynora" wrote:

I'm trying to create a spreadsheat that will keep track of when our patients
are due for supplies. For example, they can get a certain supply every 6
months. I want the date to turn yellow when we are at the 5 month mark and
red at 6 months
I have a date in cell C2 and have a formula in C3
=C2+180

Thank you so much it works perfectly!

"Luke M" wrote:

Assuming you 150 days = 5 months.
On whatever cell you want to change colors, Go to Format, conditional
formatting.
Change first box to "Formula is"
Type
=TODAY()C2+180
go to format, pattern, select red.
Add another condition
formula is
=TODAY()C2+150
format, pattern, select yellow

Note that these formulas are exclusive (C2+150 days exactly is not yellow).
If you want them to be inclusive, change comparisons to "="
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lynora" wrote:

I'm trying to create a spreadsheat that will keep track of when our patients
are due for supplies. For example, they can get a certain supply every 6
months. I want the date to turn yellow when we are at the 5 month mark and
red at 6 months
I have a date in cell C2 and have a formula in C3
=C2+180