Is there anyway to write a formula to have change the color of the font in one cell to match the color of the font in another cell? For Example I have a column where I manually enter numbers and color code them either Red or Blue. I have another column that is a formula to equal the value entered into the first column or somtimes in that column I will replace the formula with manually entered numbers. My desired outcome would be if the value in the second column is hand entered then I would want the font to be black, but if it is the formula to equal the value of the first column I want the font to match the font I entered in the first column, either red or blue respectively. There is no way to do this in conditional formatting, I don't see any where where it will recognize the font color in another cell and base the out come on that parameter.