Get the notificatin in date column

[BHAV2404]

Hi,

I am new In this forum and I am sure will get the right solution of my query,

As I have data sheet in excel 2010 to manage my warehouse procedure. we have to enter the date when we receive the Items from customer.

I want to get some kind of notification( linke pop-up message, font color change ).

for example ( I have received the Item today on 04/06/14, I want to get notification after 10 days on 14/06/14 about that same enter date)

Any solution ??

[Fotis1991]

Hi

Using Conditional Formatting, assuming that your enter date is in A1, then in CF rules put this.

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[BHAV2404]

Hi,
Fotis

thanks for you reply !

I used the formula you send me : =today()=a1+10

Its doesn't seems right , that what I am looking for..

" Is there any possibility to check, where In my worksheet I entered the one of the date 23/05/14.. and I can see that date raw in RED today "

sorry, If I mentioned the wrong way

[sktneer]

You completely change your requirement. Fotis provided you a solution as per your requirement in post#1.
It would be helpful if you provide a sample workbook with enough sample data in it along with the desired output filled manually.

[BHAV2404]

Hi,
sktneer

I didn't change my requirements, even though kindly find attach sample workbook how I want to get It done..



Thanks

[dksodhi]

Try conditional formatting:

Condition 1:
Cell value between =today() and =today()-10 and select fill with yellow

Condition 2:
Cell value less than or equal to today()-10 and select fill with red

Should work for you.

[BHAV2404]

HI,
dksodhi

Thanks for your suggestion.. Its work fine, but I need some formula which can turn today's date after 10 days ( Exmp : when I enter 04/06/2014 In date column, after 10 days on 24/06/2014 Its turn In RED color )

[sktneer]

Try this formula for conditional formatting. See the attached sheet to follow the instructions to apply conditional formatting.

Please Login or Register  to view this content.

[dksodhi]

not sure what you mean.
check the attached file and see if it works.

[BHAV2404]

Hi,
sktneer

It perfectly working fine ! that's what I was looking for !!

Thanks a lot !

[sktneer]

Glad I could help. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.