Conditional Cell color change

[Todd Huttenstine]

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

 

[Vasant Nanavati]

I don't think I understand the question. What does conditional formatting
have to do with copying and pasting cells?

 

[Guest]

Nothing, I was just telling you that in case it was
important. I didnt know if it would be important info.

 

[David McRitchie]

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.