Formula for cell format?

[atran]

Hi,

Is there a formula to identify the format of a cell? For example, I
have a sheet with colored cells (eg. red and green) I want to match
with another sheet to see if the corresponding cells on Sheet 2 are the
same color as that on Sheet 1.

Much appreciated,
A

 

[Ron Rosenfeld]

Hi,

Is there a formula to identify the format of a cell? For example, I
have a sheet with colored cells (eg. red and green) I want to match
with another sheet to see if the corresponding cells on Sheet 2 are the
same color as that on Sheet 1.

Much appreciated,
A

Need more information:

If the cells are manually formatted, you will need a Visual Basic User Defined
Function.

If the cells are formatted using conditional formatting, you will need to use
the same logic used by the conditional formatting equation.


--ron

 

[Guest]

Hello atran. You might some help on Chip Pearsons' site:
http://www.cpearson.com/excel/colors.htm