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