Lookup formulas using colors

[karenlee]

Wondering if it is possible to use whatif or lookup formulas to detect colored cells instead of using macros.

[dwint]

if you want to find a cell based on its value, you can use both formulas and macros, but if you want to find a cell based on its interior, only macros that can do