driller, thanks for the formula...I'm havinig problems though....

=AND($E$1:$E$101)=TODAY(),($E$1:$E$101-TODAY())<=60,($E$1:$E$101-TODAY())=31)

I need to have it cover the row so I modified your formula and it's not
working...can you pleae help me again? The expiration date is in colum E so
E1:E101 will work.

Thanks so much for your time.
--
Jules


"driller" wrote:

1. spreadsheet which has expiration dates in Column B I
2. from 0-30 days

FormatConditionalFormattingCondition 1
Formula is : =AND($B18=TODAY(),($B18-TODAY())<=30,($B18-TODAY())=0)
Format choose color 1

3. for 31-60 days

FormatConditionalFormattingCondition 2
Formula is : =AND($B18=TODAY(),($B18-TODAY())<=60,($B18-TODAY())=31)
Format choose color 2

....hope you have fun choosing the color...

4. To Protect : learn to read Help files...it will do good to be happy with
your spreadsheets.


"Jules" wrote:

I have a spreadsheet which has expiration dates in Column B I am using this
formula in coditional formating to have it highlight the row when its 30
days from expiration.

=IF(AND(ISNUMBER($E18),$E18<(TODAY()+30)),TRUE,FAL SE)

I need it be be from 0-30 days and I need one for 31-60 days...can anyone
tell me how to do this...or tell me if there is a better way? Also, how can
I protect the formula but allow folks to do the data entry?

thanks, I am trudging the road to happier spradsheets!
-- Jules