Hi,
I have three Column name
1) Cheque Deposit date
2) Activation Date
3) Status
What I am doing is
I collect 100 cheque daily and get clearance from my bank.
If Activation Date Exceed three days it should be flag.
On 2 column it should get flag.
Regards
Nittin goel
Thanks in advance sample.xlsx
Hi
In Conditional Format rules, try this formula.
=AND($B2<=TODAY()-3,$B2>0)
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.
Fotis,
You didn't get me I means to say whether there is activation date or not but if cheque is not cleared within three days it get flagged.
Last edited by Cutter; 09-19-2012 at 11:03 AM. Reason: Removed whole post quote
..Not sure if i get you, even now..
=AND($B2<TODAY()-3,$C2="Services Pending")
???
Or else, pls tell me in your example which rows must be flagged and why?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks