Excel 2016: Format cell based on whether two other cell colors match

Question

Is it possible to use conditional formatting to color a cell if the colors of two other cells match each other?

Answer 1

There is no formula that can read what color a cell is. Color is not data. don't use cell fill as metadata. Instead, use conditional formatting with logic that can be applied further down the calculation chain.

So, instead of coloring cells yellow manually and then trying to figure out a way to sum all cells where the next one over is yellow, use conditional formatting to set the cell yellow based on a status or value in another, corresponding cell. Then you can use that status or value in the corresponding cell to determine if the cell should be included in a further calculation like a conditional sum.