related text change font color

**Saut1** · 03-23-2009, 03:27 PM

Hello again,
I have been presented with another problem. I want to take a cell example A1 and put a 1 in it. Then take B1 and put text in it. Then if A1 is a one it will turn the font in B1 to red. Does that make sense? I hope so. I have tried different things with conditional formatting and custom function but can not get it to work. Please help.

Thank you,
Wendy

**ChemistB** · 03-23-2009, 03:40 PM

Selecting B1, conditional formatting Formula is

Please Login or Register  to view this content.

and format the font to red (I usually go with bold too). Is that what you wanted?

**Saut1** · 03-23-2009, 04:29 PM

Not exactly but we are close. What I need it to do is change whatever text I have in B1 to red. The formula you gave change the cell to true or false but colored the font red, which is what I want.

Wendy

**shg** · 03-23-2009, 05:33 PM

Select cell B1, do Format > Conditional Formatting, change the drop-down to Formula Is, and paste Chemist's formula in the next box.

Then click Format, and set it as you wish.

**Saut1** · 03-24-2009, 10:36 AM

IT WORKED!!!!! Thanks so much!

Wendy

**shg** · 03-24-2009, 10:43 AM

Great. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes