Hello,*

I am trying to tie two worksheets together. If text found in one cell in sheet1, make the same cell on sheet2 different color.*

There is a catch... no formula can occupy the cell in sheet2.*

My question is, is there a way of have a formula in completely different cell that will eventually fill the cell on sheet2 with proper information?

To explain a little better, I am trying to tie the sheets together, same cells and everything so when information gets put inside the cell on sheet1 the same cell on sheet2 will change color or display different information, and vice versa. That is the reason no formulas can occupy those cells.

Help is greatly appreciated. If needed better explanation, please let me know.*

Thank you!