Discover latest Indian Blogs Excel Shortcuts - Conditional Formatting Skip to main content

Excel Shortcuts - Conditional Formatting

# Little Savings

Conditional Formatting will help to highlight the cells if specific condition has met. Suppose, if you want to highlight the amounts less than 100000 in a column with one color and equals to 10000 with one colour, conditional formatting will help to highlight the cells.

Route:
Select the rows
Go to Conditional Formatting under home tab
Select 'Highlight Cell rows'
Select the Condition

Manage Rules:
If you want to see the existing rules, go to Manage Rules under Conditional Formating.

Little Savings - Excel



Output:
Little Savings - Excel

 

Comments