Hi Todd,
Don't know what the first part of your question has to do
with Conditional Formatting.

For an example of how to use VBA instead of Conditional
Formatting see
http://www.mvps.org/dmcritchie/excel/event.htm#case
but it will depend on how cell value get changed.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Todd Huttenstine" wrote in message ...
I have a workbook that contains sheet1 and sheet2. I have
a VBA code that copies data from sheet1 Range A1:A10 and
puts that data in the corresponding cells in Range A1:A10
of sheet2.

Instead of using conditional formatting, how would I do
this using VBA?

Thank you.

Todd Huttenstine