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