Question asked by user @ Excel forum:-
I want to highlight the row which shows the maximum GPA. It has to be happened automatically at the end of GPA calculation. Here it is 21st row with a maximum value of 4.0.
In this query users want to highlight the row with the color on the basis of Maximum number in the cell.
In column AA whatever cell is having the maximum DGPA that rows should be highlighted with color.
To resolve this query our expert has given the “Conditional Formatting” option. Now let’s see how we can do it through Conditional Formatting:-
This is the way we can highlight the row on the basis of cell value.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.