Your one for 30 days works fine.

Here is one for 60 days
=IF(AND(ISNUMBER($E18),$E18<(TODAY()+60),$E18(TOD AY()+30)),TRUE,FALSE)

As far as protection goes, just (1) lock the cell with Format cell
protection, and (2) protect the worksheet, and in the options under tools
protect worksheet, don't allow them to change formatting.

--
Allllen


"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