Thread: highlight cell contain the value and text with formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ratheesh ratheesh is offline
external usenet poster
  
Posts: 3
Default 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







Reply With QuoteReply With Quote