Formula for changing Text Color??

D

danh

I don't know if this is even possible. What I would like to do is t
input a number into a column in sheet 1 and have a correspondin
number (which is already there) change font color in sheet two. So
input a number, say 3 in C10 on sheet 1 and the number 3 which is i
sheet 2 (c10) changes from black to red.
Is this possible?
thanks very much
 
D

Don Guillett

You can use conditional formatting but NOT with other sheets. SO, you need
to name the cell in the other sheet and then format>conditional
format>formula>=nameofnamedcell>format as desired.
 
G

Gord Dibben

You can use Format>Condtional Formatting for this.

First select Sheet1C10 in Insert>Name>Define. Enter a name like "mycell"(no
quotes).

Now switch to Sheet2C10.

Format>Conditional Formatting>Formula is: =mycell=3

Pick a Red Font color from Format>Font tab and OK your way out.

Gord Dibben Excel MVP
 
Top