| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I highlight text only within a cell in Xcel? | Excel Discussion (Misc queries) | |||
| formula in excel that will highlight a cell that is left blank? | Excel Worksheet Functions | |||
| Formula to highlight an entire row when certain text is present. | Excel Discussion (Misc queries) | |||
| Can I set up Excel highlight a non formula cell? | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Linear Mode
