formula for know if a cell have a color?

[jamiguel77]

Hi all.

1) how to get the color number of a cell?
2) if A1.color=yellow
B1='AMARILLO' or B1='*'

Thanks

 

[Roderick_E]

Not likely without macro/function And even then you would get rgb or hex number for the color and would have to look up in a color wheel.

 

[shg]

If the cell gets colored by the user, there's no way to do it with formula; it would require VBA.

And if you did use VBA, changing the cell color wouldn't cause the result to recalculate; Excel doesn't consider color as data.

 

[jamiguel77]

Thanks....

i ask this question because:

Excel Filter by color.
Excel Formating using colors... and other interesting operations..

Thanks

 

[deciog]

Look at this option in the forum in formula



link

https://chandoo.org/forum/threads/filter-more-than-2-color-cells.37037/

Decio