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” ...

Example The following code example creates a range of numbers and then applies a two-color scale conditional formatting rule to that range. The color for the minimum threshold is then assigned to red ...