Novice Excel User Here..... I have a employee travel spreadsheet with air travel dates in two columns. I want to be able to create a rule that will highlight all the cells in a row if the date range on that row fall includes today's date. Essentially, I am looking for a quick way to tell if someone is traveling in the event there is an emergency and I need to know if they are traveling that particular day. I have attached a sample spreadsheet.
Thank you in advance
Use conditional formatting, based on formula, so it will be =AND(Today()>=a1,Today<=b1)
something like that.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Based on the attached spreadsheet, rows 1, 2, 4, 5 and 6 should highlight red because today's date falls within that row's
date range. I applied the formula you gave and couldn't get it to work. Book 555.xlsx
Thanks for helping...
You didnt put the brackets on your second today()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks