Donna

See Chip Pearson's site methods of determining if and what type of CF is on a
cell.

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


Gord Dibben MS Excel MVP


On Wed, 8 Nov 2006 14:11:07 -0500, "Biff" wrote:

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

You can't. There's no way to test for conditional formatting. You can use a
formula based on the logic of WHY a cell is conditionally formated:

=IF(C1="some_text",D1,"")

Biff

"Donna" wrote in message
...
I have several columns. One column contains conditional formatting
returned
on a text search in the cell.

How can I set up a formula to return the adjacent cell when the cell next
to
it is highlighted for conditional formatting.

Or, how can I say If ( certain text exists in column c then return column
d)

Thanks,

--
Donna