title: how to change font color of excel cell based on other cell
body: <p>I have two worksheet in one workbook. one cell in worksheet "A" has red font color. I want to another cell is worksheet "B" have same font color and content. but the color of cell in "B" should be changed to appropriate color if font color of cell in "A" changed. </p>
  
  <p>for example :cell A1 in sheet "A" is 120 in black color. in sheet "B" cell B1 is B1=A!A1 and it is black. by changing A1 font color to Red(in sheet "A") , B1 cell color in sheet "B" remain black while I want to change its color to Red .</p>