Not via conditional formatting. You could use a worksheet_change event but
it would need considerably more information and not inconsiderable code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Craley76" wrote in message
...
Here is what I want to accomplish:


IF cell value = Expert copy row to sheet 2

IF cell value = Equipment copy row to sheet 3

Is this possible?

Thanks!