Okay...I did this and it's not working....I also tried Allllen's
method...don't know what I'm doing wrong...I pasted the formating to the
rows....using both scenarios...I've changed the dates to see if it worked
(ensure the formatting was there...) to no avail....

Sign me frustrated in B'more
--
Jules


"driller" wrote:

try it first in a save as New workbook, not in your original file...Copy
paste by Row not by Column...Row is horizontal....

"Jules" wrote:

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