Alert on date passed

can I be alerted somehow when a certain date passes? For instance in a range G11-G10000, dates are entered, if the date entered is Oct / 22 I want some sort of a warning 30 days from now. If that cell can be highlighted somehow or text color changed that would be great but an alert box could also do if nothing else is possible.

thanks

Hi,

Use Format Conditional Formatting
Cell Value Is
greater than
=TODAY()+30
Format Patterns Yellow
OK twice ...

That's it ...

HTH
Carim

i have my cell formated as custom (mmm / d)...

i assign Conditional Formatting and it's not sowing any changes, is there anything else that has to be done. I format the cell as you describe, enter a date in the past (more than 30 days) and I see no changes

Hi,

Watch out with your test ...
It is related to today()+30, so enter a test date in the future ...

HTH
Carim

when I use "Cell Value Is" it doesn't work, (non-dates actaully change formatting but not dates)
when I use "Formula Is" it highlights everything

eiher way makes no sense...

well,

May be you need just 30 days difference ...

Use Format Conditional Formatting
Cell Value Is
greater than
=A1+30 ' make sure A1 is replaced by cell you are testing ....
Format Patterns Yellow
OK twice ...

HTH
Carim

i got to the bottom of what is not working but I need your help to fix it

what you said first time worked =TODAY()+30

but instead of TODAY it has to take under consideration the date that is already entered in the cell, ie. if it's filled with Jul/14, 30 days past that day the field should change formating

Hi,


You are right ... that is the reason why in my previous post I am telling you
to change the formula from =today()+30 to =yourcell + 30 ...
your cell being the cell you are located on ...

HTH
Cheers
Carim

Originally Posted by Carim

You are right ... that is the reason why in my previous post I am telling you
to change the formula from =today()+30 to =yourcell + 30 ...
your cell being the cell you are located on ...

what if the "mycell" is a dynamic thing and can be something else everytime?
can it somehow take whatever is in the cell alraedy as source data and apply the formula to that?

Yes ...
Copying with Format Painter adjusts formula automatically ... !!!

Carim