When you deal with hundreds of rows and columns in a workbook ... You will find the option under Home > Conditional Formatting menu. These rules format cells based on their values.

If a table has multiple columns of related data, I merge the top row cells ... conditional formatting allows me to automatically apply formatting—such as colors, fonts, or borders—based ...