I have searched in all the discussions but was unable to find out if excel
can find highlighted cells.
Lets say I have a worksheet that has certain cells highlighted based off a
formula. On a seperate worksheet I want some type of If statement, such as
=If('Wkst1'!B9="yellow highlight","Y","N")
Is this possible?

If the cells are highlighted using Conditional Formatting you can find them by
stipulating the same criteria in your formula.

If the cells are highlighted manually you must use a User Defined Function.

See Chip Pearson's site for finding colored cells.

http://www.cpearson.com/excel/colors.htm

Read Chip's notes on event changes and also the caveat regarding finding cells
colored by Conditional Formatting.


Gord Dibben MS Excel MVP

On Thu, 2 Nov 2006 10:59:02 -0800, Gayla
wrote:

I have searched in all the discussions but was unable to find out if excel
can find highlighted cells.
Lets say I have a worksheet that has certain cells highlighted based off a
formula. On a seperate worksheet I want some type of If statement, such as
=If('Wkst1'!B9="yellow highlight","Y","N")
Is this possible?