With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

Individually apply conditional formulas for each cell, and each cell has 2 conditional color scale rules. To begin, select cell A1. Create 2 color scale rules that only apply to cell A1.

Q. Is there a way to color-code cells based on their cell content? For example, if cells state “Woman-Owned,” could those cells automatically become red and the cells that state “Large Company” ...