Conditional Formatting or IF function
 

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

Conditional Formatting or IF function
 

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+90TODAY())
Format: brown fill

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

The precautionary criteria: $B1<""
is to ensure that any blank cells in col B will not spuriously trigger the CF
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Danny" wrote:
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

Conditional Formatting or IF function
 

Thank you Max. You just made my day!

"Max" wrote:

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+90TODAY())
Format: brown fill

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

The precautionary criteria: $B1<""
is to ensure that any blank cells in col B will not spuriously trigger the CF
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Danny" wrote:
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

Conditional Formatting or IF function
 

Welcome, Danny
Pl click the "Yes" button below,
from where you're reading this message
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Danny" wrote:
Thank you Max. You just made my day!