Conditional Formating A Row

[Jules]

Hi, I have a spreadsheet of items that need to be watched for expiration....

Column E has the Expiration Date...

I need a formaula (I think for the conditional formating) to have the row
highlight when the it's 60 and 30 days to expiration.

I tried the =and(E1:E1000<>"",today()-30)

It did not work....

Thanks any help would be appriciated.

 

[Bob Phillips]

Select rows 1 though 1000
Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =AND(E1<TODAY()-30)
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
Click Add>>>
Change Condition 1 to Formula Is
Add a formula of =AND(E1<TODAY()-60)
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK




--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Mike Campbell]

It sounds like you need two conditions in your formula: one for 0-30 days and
one for 31-60 days. Try these formulas:
=AND(($E1-TODAY())>0,($E1-TODAY())<31)
=AND(($E1-TODAY())>30,($E1-TODAY())<61)

Make sure you start at A1, select your rows to format, then go to
Conditional Formatting write these formulas. You may also want a formula for
greater than 60 days:
=($E1-TODAY())>60