conditional formatting

Hi All,

I have a sheet like that
A B C
1 140101 10 John
2 140102 11 Peter
3 140102 11 John

I want to use conditional to highlight the whole line when column A is the last day.
I can do that for column A. but I don't know to how to set the conditional formatting for column B and C.

Thanks.

You need to set the cell reference to absolute with a $.

So, if your conditional formatting formula was something like =A1=max(A:A) then change it to =$A1=max($A:$A) and apply it to all three columns.