highlight cell contain the value and text with formula
 

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

highlight cell contain the value and text with formula
 

Assuming your data in A1:D6

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

format any color you like


"ratheesh" wrote:

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

highlight cell in the blank row from the total marks row with for
 

"ratheesh" wrote:

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