asked on

Excel 2007 how to link cells for colour eg. Cell A1 sheet1 colour green, want Cell A1 sheet2 to change automatically to same colour when ever changed

Hi,

I am looking to have a group of cells on sheet 1 different colours depending on their status. eg. Red = not done, yellow = in progress and green= completed.
I have another sheet in the workbook which i want to automatically pick up the cell colour on sheet1 and change to the same colour.

I have checked out conditional formatting and this only appears to work if there is a value in the cell which there wont be in this case.

Any ideas much appreciated.

Rob Henson

Conditional formatting can refer to another cell, it doesn't have to be reliant on the cell in which the formatting is being applied.

For example, you can turn a whole row green based on the contents of one cell in that row.

If you have some sort of status value on your first sheet you can use that as the indicator for the colour of the cells on that sheet and on the second sheet.

Thanks
Rob H

yahooooo

See attached. You could tackle it like this
Book1.xlsx

TonyHaughton

ASKER

Cheers guys, unfortunately they don't want to have any values in the cells.

The idea is to manually update the colours on sheet1 and the colours on sheet2 change accordingly to match sheet1.

see basic rough example attached.

so would like the summary sheet to replicate the work sheet colours and if change the colour of a cell on the work sheet would like the summary sheet to update automatically.
example.xlsx

ASKER CERTIFIED SOLUTION

yahooooo

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

TonyHaughton

ASKER

Excellent, works a treat.

Thanks for all your help