Hi guys,
I need some help. I've got a workday formula which adds two days to the start date. Following that I would also like to be able to highlight those cells that have no days remaining Ie. Start date + 2 days= today.
I'm not sure if conditional formatting is the way to go or not.
Any help, as always, appreciated guys.
you can do this using conditional formating. Highlight the cells you want to use the formating on, then click the "conditional formatting" button, go to "highlighted cells rules", then click "a date occurring". Next use the dropdown and make it "Today", then choose the kind of highlighting you want, if you don't see what you want there you can always choose "custon format" and make your own style of formatting.
Regards,
amotto
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Worked perfectly cheers!
Simple question, simple solution. This forum is great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks