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