IF statement dependent on cell fill color

[jardenp]

I would like to have a formula in, say, cell A2 that determined if cell A1 had a fill of either of two standard colors (the ones labeled "standard colors when you drop down the fill menu) and then returned a value--orange=1 and blue=2. If the cell isn't filled with one of the two colors, I want the result to be "" (blank). Is there a way to do this?

Something like =IF([fill of A1]=[orange], 1, IF([fill of A1]=[blue],2,""))

For a couple reasons, I can't use VBA/Macro for this. I know it can be done that way but I'm looking for a worksheet-formula-only solution.

Thank you!

JP in IN

 

[tyty123]

Is it possible to do something like this?

=IF([fill of A1]=[Green], IF ([fill of B1]=[Green],2,""))

Looking to get a yes if all 4 cells are green

 

[jardenp]

Is it possible to do something like this?

=IF([fill of A1]=[Green], IF ([fill of B1]=[Green],2,""))

Looking to get a yes if all 4 cells are green

This is a blast from the past! I don't even remember what sheet or script I was referring to. I think this has what you need: How to Get the Cell Color in Excel (2 Methods) - ExcelDemy

In corporate that into your sheet and IF formulas.