Copying cell highlighting from one cell in a sheet to another cell on a different sheet

Have a look at this thread, which uses a macro to copy the cell colours of cells to other cells, and see if it might help: http://www.excelforum.com/excel-form...lls-value.html
If you can't get it to work for your file, let me know and I'll try amending it for you.

I've amended the macro to run on your original example file - here's the amended version: Copy cell colours sheet2 to sheet1 _ for rvgmec.xlsm
Click Alt-F11 to open the VBA editor, then right-click on 'Sheet2 (Sheet2)' and select 'View Code' - you'll then see this code:

Please Login or Register  to view this content.

Any time a change is made to C2,C3,C4 or C5 on Sheet2, this code will run, copying the colours as follows:

C2 → Sheet1 B3
C3 → Sheet1 D5
C4 → Sheet1 A2
C5 → Sheet1 H7

If you make a change to any other cell, the code won't run (because there's no reason for it to).

Does that work for you?

You're welcome, glad to be of help.

If that solves your problem, please mark the thread as 'Solved' using the 'Thread Tools' above your first post - this keeps the moderators happy and means other members don't waste time reading problems which are already fixed. Thank you.

I got your PM saying that this isn't working in 2007, but working in 2010. I'll reply here so that others can see the problem and possible solutions.

I don't have 2007, so can't test it there, but a quick search suggests two possibilities:
1.
Are macros enabled? In Excel 2007 they won't be if the workbook has a File Open password or if it has Workbook protection.
2.
Worksheet Events may have been turned off somehow. Press Alt-F11 to open the VBE, then press Ctrl-G to open the 'Immediate' window (it will open at the bottom right). Type ?Application.EnableEvents then press Enter. If the word 'False' appears, then events have been disabled. Type Application.EnableEvents = True to re-enable them.