Help with Formula

[Brian]

What formula would I use if for example on Worksheet 1 I
want a certain cell to highlight yellow when an X is
typed into another cell on Worksheet 2?


Thanks
Brian

 

[Patti]

I don't think you can reference another worksheet with
conditional formatting. If your cell that you want yellow
is blank, you can do this:

Link this cell with the "X" cell. =worksheet 2!A1 for
example
Change the font to yellow
Format, Conditional Formatting
Cell Value equal to ="X" and choose Formats, Patterns and
pick your color.

If you have data in this cell, use a helper cell to link
to the other worksheet, change the font to white and enter
this formula in conditional formatting:

Formula is =countif(A1,"X")=1 and choose formats, etc

where A1 is the helper cell.

 

[Don Guillett]

have a look at format>conditional format>=a1="x">format as desired.

 

[Guest]

Sounds like you need Conditional Formatting for your
target cell in Sheet 1. HOWEVER, CF doesn't reference
across sheets or books (at least not in Excel97), so
you'll have to set up a "surrogate cell" in Sheet 1 to
echo the value in Sheet 2. Color-condition your target
cell based on the contents of the surrogate. The
surrogate cell can be in an out-of-the-way place on Sheet
1, placed in a hidden row or column, or formatted to be
invisible (eg: color on same color). Just don't forget
it's there and what it's for!

Maybe someone else has a better idea, but this has worked
for me okay. If you need specifics on Conditional
Formatting, post back.

Hope this helps.