hi,
I have the days of the month (Just weekdays) in col B with the first date starting in B2.
I'm looking for a formula or a way using conditional formmating to highlight yesterday, the problem I find is when its a monday I want it to highlight the last entry which would be a friday because I'm excluding weekends. I also want it to highlight the full row in the table so from A-H.
Any ideas
Thanks
Hi
Highlight your whole range.
In CF rules put this formula.
Formula:
Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
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.
=NETWORKDAYS($B2,TODAY()-1)=1
Try this formula in Conditional Format
If it is not working attach sample excel file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks