How to Highlight a row on the basis of Cell

Question asked by user @ Excel forum:-

How to highlight the row on the basis of cell value through Conditional formatting ?

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.

image 1


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:-

  • Select the range DGPA AA8:AA46.
  • Then click on “Conditional Formatting” drop down list will appear, where we have to select “Manage Rules”  dialog box will get open.
  • Where we have to click on “New Rule”, New Formatting Rule dialog box will get appear, click on Use a formula to determine which cells to format.
  • =$AA8=MAX($AA$15:$AA$53)
  • Click on Format and select the green color.

image 2


  • Click on Format and select the green color.
  • Row will get highlight with the selected color.

image 4

This is the way we can highlight the row on the basis of cell value.



Main Page

Conditional Format Based on Dates

Find Occurrence of Text in a Column

How to Highlight a row on the basis of Cell

Compare 2 Columns and Return Fill Red if is different

How to check the row and then highlight the first cell of the row

Highlight Cells Tomorrow Excluding Weekend

Conditional Formatting to Mark Dates on a Calendar

How to apply Conditional Formatting  in a Cell before a Particular Character

Highlight the Top 10 Sales through Conditional Formatting

Conditional Formatting for Pivot Tables

Conditional Format Between First and Last Non-Blank Cells




Users are saying about us...

  1. I believe the statement "Select the range DGPA AA8:AA46" should be "Select the range DGPA A8:AA46" (A8 vs AA8) to get the entire row to highlight. The actual example in the workbook is correct.

    • Hi Ron,

      Thanks for bringing in our notice.

      The formula is used in conditional formatting to highlight the row basis on highest DGPA from the column range AA8:AA46.

      Team Excel Tip & Excel Forum

    • Hi Ron,

      Thanks for your feedback. We have checked it and observed that due to incorrect range, it was highlighting the highest DGPA from AA15:AA56.

      Now we have updated the sheet.

      Team Excel Forum & Excel Tip

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube