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.

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

Little Savings - Excel