I am trying to create a formula that can red the text color from another cell....so =if (e4cell red),then "e12-100") Can something like this be done?

It can be either the cell text color or I can fill the necessary with color