Formula for changing Text Color??

  • Thread starter Thread starter danh
  • Start date Start date
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
 
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.
 
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
 
Back
Top