Conditional Formatting

LavanyaS

Shall we implement Conditional Formatting extensively out here - any tricks

Mike Wilday

Use your judgment. Whatever formatting you do use should be clear and easy to understand. If you have to create a separate sheet to explain the formatting you're probably going overboard.

Humashankar

Absolutely

You can identify the data or conditions you want to highlight

Select the range of cells and apply conditional formatting

Go to format for formatting

Choose the type of formatting

Set the rules and criteria

preview and apply and thats all

It helps in identifying patterns, trends and more

Mike Wilday

Use your judgment. Whatever formatting you do use should be clear and easy to understand. If you have to create a separate sheet to explain the formatting you're probably going overboard.

LavanyaS

Thanks

Humashankar

Absolutely

You can identify the data or conditions you want to highlight

Select the range of cells and apply conditional formatting

Go to format for formatting

Choose the type of formatting

Set the rules and criteria

preview and apply and thats all

It helps in identifying patterns, trends and more