Hi diller...will the formula work throughout the column? I think that is
when I got into trouble....I tried to change it to a range...to no avail :(

Thanks Diller.
--
Jules


"driller" wrote:

1. spreadsheet which has expiration dates now in Column E not B
2. from 0-30 days
click Row 18 if u see it completely dimmed go to
FormatConditionalFormattingCondition 1
Formula is : =AND($e18=TODAY(),($e18-TODAY())<=30,($e18-TODAY())=0)
Format choose color 1

then
3. for 31-60 days

FormatConditionalFormattingCondition 2
Formula is : =AND($e18=TODAY(),($e18-TODAY())<=60,($e18-TODAY())=31)
Format choose color 2
hit enter
then copy the whole row 18
then select all rows downward or upward see it dimmed?
then click EditPaste Specialclick format onlyenter

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


"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