Conditional Formating

[Dan]

Looking for an equation similar to Conditional Formating. Instead of
formating the cell results I want the values returned in a different sheet.

Also is there a way to return the entire row that the result is in?

Thanks

Dan