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


--
atran
------------------------------------------------------------------------
atran's Profile: http://www.excelforum.com/member.php...o&userid=24540
View this thread: http://www.excelforum.com/showthread...hreadid=468813

On Mon, 19 Sep 2005 10:01:55 -0500, atran
wrote:


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

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

--
Sincerely, Michael Colvin


"atran" wrote:


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


--
atran
------------------------------------------------------------------------
atran's Profile: http://www.excelforum.com/member.php...o&userid=24540
View this thread: http://www.excelforum.com/showthread...hreadid=468813