connect two worksheets together Solved/Closed

Question

Hello, 

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!

Configuration: Mac OS X / Safari 10.2.1.2141

ac3mark · Answer

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.

rookie · Answer

Awesome! Thank you ac3mark. 

Greatly appreciated.

Connect two worksheets together

2 responses

Similar discussions

Subscribe To Our Newsletter!