However, it can also be used to find and replace the color of ... as follows: Excel will alert you with the number of replacements made in the entire sheet or the selected cell range.

And you might have done that already in Excel or Google ... to highlight duplicate cell values. In a similar manner, you may use conditional formatting to assign colors to items in a dropdown ...