Hi there, this is my first post so hopefully I give enough detail.

I have a sheet with cells that change colour whether they are online or offline. (green online, red offline). what I am trying to do is when these cells are changed to either offline or online (colours also) then I want another cell representing that cell to change to the same colour also. I have tried but keep failing with the macros.

So basically when a cell turns red or green the other cell on the other sheet changes to match it automatically. If anyone can help I would really appreciate it as I have been stuck on this for weeks now and cant seem to find anything online that works.

If I haven't put enough info I can add more if required. Also I am using Excel 2010 if that helps also. Or if it would be easier I can upload a template of what I am trying to do as I cannot upload the real file

Thanks in advance