Conditional formatting between sheets

**scottrobby** · 08-06-2008, 10:26 PM

I need to change font color to red in sheet1 and sheet2 when corresponding cells are not equal in range. Also need sheet3 to show differences and sheet4 to show averages between sheet1 and sheet2. I've had not problems with formulas for sheet3 and sheet4, but would like to be able to do it in vba. Changing the font colors has been giving me fits.

Thanks

Scott

**protonLeah** · 08-06-2008, 11:21 PM

Please Login or Register  to view this content.

**scottrobby** · 08-07-2008, 06:54 PM

Thanks for your reply Ben. When I run this sub I get a runtime error 9. Subscript out of range. This is the same error I have been getting trying this on my own. What am I doing wrong or missing? It hangs here> Set Data1 = Sheets("Data1").Range("A2:I46"). Also, using excel 2002.

Thanks,
Scott