highlight cell contain the value and text with formula

  • Thread starter Thread starter ratheesh
  • Start date Start date
R

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
 
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 said:
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
Click to expand...


name marks
RATHEESH
SUJITH
SRIJITH
SURESH
PRASANTH
 
Back
Top