How To Set Cell Color Equal To Another Cell Color In Excel?

I want to fill font color green based on cell color on another sheet cell.

"Making" sheet Q2 have value 850 with font color green.

i want "account formula" sheet E2 with value 850 with green color.

I attached Excel Sheet. Please help me to solve this puzzle..

Excel is not capable of making automatic changes elsewhere based on you changing the format of a cell.

Even if it was possible, there is no logical connection between the 2 cells other than the value of 850. Any change routine based on this would colour every cell containing 850 green, not just the one you want.

There is no connection to the value "850". i just want same color of font from one sheet cell to another sheet cell.

Reiterating my previous comment, excel is not capable of doing what you ask automatically. You will have change both from the menu.

For it to be done automatically, there has to be a connection between the 2 cells. Changing the colour of one of the cells is not considered a connection.