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