> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/conditional-formatting.md).

# Conditional Formatting

**Conditional Formatting**

\
Conditional formatting quickly highlights important information in a spreadsheet. But sometimes the built-in formatting rules don’t go quite far enough. Adding your own formula to a conditional formatting rule gives it a power boost to help you do things the built-in rules can’t do.

**Short Key --> Alt + H + L (Using Alt Key Concept explained in Short Keys Section)**

![](/files/-LRatT7cQFXXIqNAajXo)

{% file src="/files/-LRat\_l93FWp7gQRad25" %}
Example for Conditional Formatting
{% endfile %}