Hi,
I have a log that has several entries put in each day.
I would like to have conditional formatting so that anything with today's date has the formatting (say, Bold type).
Can someone please assist me? I just can't seem to make it work.
Thanks as always, Paul.
Hi EdWoods,
Yes it can be done can you post sample workbook here with expected result.
Thanks
Ankur
Hi,
Please see attached.
While today is 10/5/16 (in dd/mm/yyyy format), entire line to be bold.
If I open up tomorrow (11/5/2016), it's no longer bold.
Cheers.
Select the whole date and then press ALT->O->D, you will get a window naming conditional formating rule manager -> click on new rule you will get new formatting rule->select the last option called use as formula to determine which cells to format-> put =TODAY()=$A2 this formula into format values where this formula is true-> now click on format and format cells as you want then apply and then ok.
Now the conditional formatting will work.
Check the attached file.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Ah, thanks. I was using NOW(), not TODAY()
Cheers
Glad to help you and thanks for feedback and rep!!! :
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks