![]() |
#1
|
|||
|
|||
![]()
I have a basic time sheet with the 'Date' in column B (dddd dd/mm/yyyy), 'time in' in D, 'Lunch out' in E, 'Lunch in' in F and 'finish' in column G, columns D-G are in number format [H]:mm AM/PM I have already used conditional formatting to highlight the current day in column B using the =today() formula.
(column)B...............D..................E...... ...........F...................G ................ Date...........Time In........Lunch Out.......Lunch In..........Finish Saturday 15/11/2014....07:30AM........12:00PM.........13:00pm.... .....17:30PM Sunday 16/11/2014......08:30AM........12:00PM.........13:00PM.. ........21:00PM How do I format columns D-G to do the same as Column B? so basically i want the row with today's date to be highlighted I have tried this method below with no success so any other method would be great First select all the cells in column D-G as far down as far as you have dates in column B. Then, while holding down the CTRL button, select all the rows in column B with dates, starting from B2. If the top cell that got date is B2, then use this formula in Conditional Formatting: =$B2=TODAY() Hope this makes sense. |
#2
|
|||
|
|||
![]() |
#3
|
||||
|
||||
![]()
The method described in bold in your first post works perfectly.
Please post a sample sheet( no pics) so we can see what is wrong
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
![]() |
#5
|
||||
|
||||
![]()
Like this?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
![]()
thanks Pecoflyer
Now I can see how you did it it looks easy problem solved ![]() |
#7
|
||||
|
||||
![]()
You're welcome ( the trick is the $ sign
![]()
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
MSofficeBLUE | Excel | 2 | 10-15-2013 09:51 PM |
![]() |
dlowrey | Excel Programming | 3 | 05-12-2013 08:30 PM |
![]() |
alysolyman | Word VBA | 1 | 03-27-2013 02:46 PM |
![]() |
Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |