Highlight Top 3 and Bottom 3 Values | Conditional Formatting | Practical Example

In this Excel video tutorial, we will learn how to Highlight the largest and smallest values in Excel, top 3, top 5, top 10, etc., or Automatically paint the cell green and red or paint the entire row in Excel, highlight colored cell in Excel with Practical Example

Conditional formatting in Excel is a powerful way to visually highlight data based on certain conditions. We can automate tasks in Excel and save time in our daily lives, as well as helping us in the job market and job interviews.

To highlight positive and negative numbers in Excel.

Select the range of cells that contain the numbers.
Go to the "Home" tab and click on "Conditional Formatting".
Choose "New Rule" and select "Format cells that contain..."
In the first drop-down menu, choose "Less than" and in the field next to it type "0".
Under "Format with", choose the accent color for negative numbers.
Repeat the same process to highlight positive numbers, choosing "Greater than" and the corresponding color.

To highlight duplicate values in Excel.

Select the range of cells you want to check for duplicates.
Go to "Conditional Formatting" and choose "New Rule".
Select "Format cells that contain..."
In the first drop-down menu, choose "Duplicate Values".
Choose a highlighting format for duplicate cells.

To identify trends and patterns in Excel.

Suppose you have a table with numbers in columns or rows.
Select the column or row you want to format.
Apply a conditional formatting rule using "Color Gradient" or "Data Bar" to visually show the trend of numbers (for example, the larger the number, the darker or more intense the color).

To assign colors based on specific criteria in the table.

For example, if you have a list of students and their grades, you can assign different colors based on their grades, such as green for grades above 90, yellow for grades between 80 and 90, and red for grades below 80.
Use a new conditional formatting rule and select "Use a formula to determine which cells to format."
Write a formula that evaluates the desired condition and assigns the corresponding color.

To highlight upcoming due dates or past due dates. Expiration date.

Select the range of cells that contain dates.
Apply a new conditional formatting rule using "Next Date" or "Previous Date" and set a range of days to highlight dates that are close to or behind today.

#JopaExcel #Dashboard #Excel