Connect two worksheets together

rookie - Apr 1, 2014 at 10:33 PM
 rookie - Apr 3, 2014 at 09:56 AM

I am trying to connect 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!

2 replies

Blocked Profile
Apr 2, 2014 at 10:33 AM
OK, there is a built in function called "conditional Formatting". I will post some pictures to describe how it works.

Pick your cell, make a fomrula in th econditional formatting tool, and viola. Check it out:

second step, build the formatting:

End result:

I hope this helps how to use Conditional Formatting. There are really no formulas on the sheet.

Awesome! Thank you ac3mark.

Greatly appreciated.