Solved Excel: Change font color on other worksheets

August 25, 2011 at 17:26:59
Specs: Windows 7
Is it possible to change font color of a text in other worksheets is it is input to a cell in a different worksheet in Excel 2010? For example, Worksheet 1 has "Hello" in a certain cell. (Hello will only be used once on the worksheet.) I need "Hello" to turn red in Worksheet 2, Worksheet 3 etc.

If so, please explain how.

See More: Excel: Change font color on other worksheets

August 25, 2011 at 18:47:23
✔ Best Answer
It sounds like Conditional Formatting should work.

Let's say the cell where you will be entering Hello is Sheet1!A1

In Sheet 2 click in the box above the Row numbers to select all cells.

Home...Conditional Formatting...New Rule...Format only cells that contain...
Cell Value...equal to...=Sheet1!$A$1...Format...Font...Color...Red

Whenever any cell in Sheet 2 matches the contents of Sheet1!A1, the font will be Red.

Note: The dollar signs ($A$1) are required.
Note 2: You must follow this procedure for each sheet, one by one. It won't work if you group the sheets because the Conditional Formatting feature is not available when sheets are grouped.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 28, 2011 at 12:06:39
Thanks DerbyDad03! Appreciate your help. It worked as I was hoping.

Report •
Related Solutions

Ask Question