Hello everybody I have the below problem if someone can help me:
we have a date in a cell let's say : 20/07/2014 (present day 16/05/14)
I need to add a conditional formating rule so when the present/real date will reach 15days before the 20/07/14 and until the speaking date the cell will be colored as notification to upcoming deadline (20/07/14)....
Meaning that the cell will be colored on 05/07/14 and 06/07/14....etc. until 20/07/14.
Thansk for your help in advance.!!!
Hi
say column B
Highlight B2:B22
Look top say Conditional Formatting click on,
click: Manage Rules,
Click: New Rule,
Click: Format only cells that contain,
Keep "Cell Value", next "between" change to "Less than", next =TODAY()+15
Click: Format,
Look top click: Fill,
Click: any colour you choose, (Make sure you see colour in Sample box)
Click: OK ,
Click: OK,
Click: Apply,
Then it you done!!.
Regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Check out the attached workbook. Do you want the conditional formatting like this?
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Thanks both for your reply.!!!
maybe I did not explained correct I believe that the attachment will make clear what I am trying to do....
reaally thanks for your time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks