Cell Colour Help

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

Hi there I have attached an example of what I am trying to achieve. Its not so much the sheet name or cells as I can change them its the coding itself I am getting no where with.

On the file attached on the front sheet when a pump goes down someone changes it to offline. What I am trying to do is when they change it to offline and it goes red I want it to mirror on another sheet so it updates the other sheet automatically to match so at no point will one sheet say something different from the other so no confusion is caused. When I am finished work I can create a copy and go into more detail and supply more info as well. Apologies if this is making no sense but ill try when I am not working. Thanks for the quick response though.

Thank you. Works perfect. Very much appreciated

Sorry to be a pain. If I was only using the colours and green represented being online instead of having the word online in the cell and just the colour would this be possible ?

Thanks for the quick replies. I have this working now and just have one more little snag though.
If I had say 2 cells which where either green or red can you specify or point to a specific cell to look at ? Instead of the online / offline bit in the code like if cell A1 was red then copy that colour to a specific cell? If A1 was green then copy that cells colour to the other sheet to a specific cell on the other sheet.

Just in case I have to add more if that makes sense. Thank you very much for helping as I am stuck at this last hurdle.