Conditional Formatting or IF function

[Danny]

Hi,

I have a worksheet that on Col A I need a "tickler" to prompt me to update a
particular row based on date requirement on column B (i.e., every 30, 60 or
90, etc days).

I came up with a conditional formating on Col A, row 2:
=datevalue("2/25/2008"), will make a yellow background/pattern

Right now, I have to adjust the dates every 30, 60, days to promt me to
update.

An if function will also do: (please edit the formula below)

=IF(NOW()>=DATEVALUE("1/3/2008"), ">>> Update!","****")

If there a way to edit my conditional formatting or if formual to make it
prompt every 30, 60, etc. days.

Thank you in advance.

Danny

 

[Max]

Presuming that you want entire rows to be conditionally formatted based on
the dates in col B (dates in col B are assumed real dates) like this:

red, if date in col B is >= 90 days old
brown, if date in col B >= 60 days old, but < 90 days old
yellow, if date in col B >= 30 days old, but < 60 days old

Select the entire sheet (A1 active),
then apply CF using "Formula Is" for conditions 1,2,3 as:

Cond1: =AND($B1<>"",$B1+90<=TODAY())
Format: red fill

Cond2: =AND($B1<>"",$B1+60<=TODAY(),$B1+90>TODAY())
Format: brown fill

Cond3: =AND($B1<>"",$B1+30<=TODAY(),$B1+60>TODAY())
Format: yellow fill

The precautionary criteria: $B1<>""
is to ensure that any blank cells in col B will not spuriously trigger the CF

 

[Danny]

Thank you Max. You just made my day!

Presuming that you want entire rows to be conditionally formatted based on
the dates in col B (dates in col B are assumed real dates) like this:

red, if date in col B is >= 90 days old
brown, if date in col B >= 60 days old, but < 90 days old
yellow, if date in col B >= 30 days old, but < 60 days old

Select the entire sheet (A1 active),
then apply CF using "Formula Is" for conditions 1,2,3 as:

Cond1: =AND($B1<>"",$B1+90<=TODAY())
Format: red fill

Cond2: =AND($B1<>"",$B1+60<=TODAY(),$B1+90>TODAY())
Format: brown fill

Cond3: =AND($B1<>"",$B1+30<=TODAY(),$B1+60>TODAY())
Format: yellow fill

The precautionary criteria: $B1<>""
is to ensure that any blank cells in col B will not spuriously trigger the CF

 

[Max]

Welcome, Danny
Pl click the "Yes" button below,
from where you're reading this message