excel - Conditional formatting from another cell

Question

I would like to know how to conditionally control formats as below:

Cell "A" can have several different inputs. Depending on what, it gets colored formatted.

Cell "B" can have a value or not. If it doesn't have it it should stay unformatted. If it has a value it should have the same color format as cell "A".

If cell "A" changes it should change the color format in cell "B" also, without changing the value in cell "B".

Can someone help me?

Answer 1

I'm not entirely sure I understand your question - an example might help.

That said, here is one tutorial on conditional formatting.

It may be slightly hairy, but I think you can do what you want. Calculate formula based on $A1 and aqpply it to $A$1:$B$100