Conditional Formatting for highlight
Hello,
Can anyone help to setup the file for notification for the following.
before 30 days blue
before 15 days yellow
before 2 days red
I want to do this Conditional Formatting for monitoring expiry date.
Sample sheet is attached for your easy reference.
Last edited by hecgroups; 03-06-2012 at 10:42 AM.
Hi
Take a look to the example.
Is it OK for you?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks it is working but i need one more thing can we have the difference of both the dates. Means i want to know the number of days difference.
You mean, by a new rule in Conditional Formatting, or just in a cell??
Just in cell i.e. column C Formula and Conditional Formatting both if possible
As i am iN Excel 2003, i can not show you 4th condition. But formula, is.
=B2-TODAY()
Copy down.
I need number of days difference in two days. Any how thanks for your help. Topic is marked a solved.
Can the last option RED color remain uptill the date is valid from before 2 days of expiry
I have solved. Thanks for your help. Topic marked as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks