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.

screen print

screen print.png

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

__________________
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

sample sheet


Sample.xlsx

Is this what you are after?

Like this?

Attached Files

Sample.xlsx (17.1 KB, 10 views)

__________________
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

thanks Pecoflyer

Now I can see how you did it it looks easy

problem solved

You're welcome ( the trick is the $ sign )

__________________
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