highlight cell contain the value and text with formula

[ratheesh]

i hv a table containing columns of names, mark 1, mark 2, and total marks.
i want to highlight the row who scored the highest total including the
persons name. how can i do it, is possible

name mark1 mark2 TOTAL marks
RATHEESH 51 1 52
SUJITH 1 100 101
SRIJITH 21 1 22
SURESH 1 34 35
PRASANTH 61 1 62

 

[Teethless mama]

Assuming your data in A16

select D1:A6
Conditional Formatting
Formula Is: =$D1=MAX($D$1:$D$6)

format any color you like

 

[ratheesh]

i hv a table containing columns of names, mark 1, mark 2, and total marks.
i want to highlight the row of name who scored the highest total in the blank marks row of the second table.. how can i do it, is possible

name mark1 mark2 TOTAL marks
RATHEESH 51 1 52
SUJITH 1 100 101
SRIJITH 21 1 22
SURESH 1 34 35
PRASANTH 61 1 62

name marks
RATHEESH
SUJITH
SRIJITH
SURESH
PRASANTH