Fill Colour of a cell based on another cell Fill Colour

**ConorK** · 01-31-2012, 06:59 AM

Hi,

this one has been wrecking my head for a while now, and i cannot seem to find any useful information on the internet about it. hope someone here can help.

Basically, i have a column in Sheet 1 that is to be formatted with red green or yellow when the corresponding cell in Sheet 2 is formatted.

the cell in sheet 2 is formatted manually and no text values or numbers are entered.

is this impossible? because i cant seem to find a solution.

Thanks in Advance.

Conor

**arlu1201** · 01-31-2012, 07:03 AM

So is it as simple as - if cell A1 on sheet2 is red, cell A1 on sheet1 should be red? Or is there some other condition to be noted?

**ConorK** · 01-31-2012, 07:09 AM

Yeah almost,

for example. in Column A there are 'parts'. We need column B in sheet1 to go red if the same part in sheet2 column C goes red. does this make sense? ive attached a sheet to better describe hopefully.