Hi,
I am currently using the following code to change the colour in cell A1 if the date in cell B1 is two days before today and cell A1 is still empty. This is to alert me that the date is approaching and pre-requisite work is yet to be complete.
=AND($B1<>"",($B1=TODAY()+2),$A1="")
Could I set it to only look at working days (mon -fri) instead of everyday?
Thanks in advance
Try in this way.
Formula:
Please Login or Register to view this content.
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.
You my friend, are a genius! Thank you so much.
You are welcome and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks