Solved: Conditional Format to a Linked Cell

[oliver]

Question. In the attached example the Conditional format in Column B looks for a value in Column A to trigger the format. The problem is Column A results are created by a link to another worksheet. The top example works great (thanks Ron McK) but now I need to do the same thing, but based on info from a link. Can the formula be modified?
Thanks Oliver

=AND($A1<>"",$B1="")

[Bob Phillips]

Change the formula in A

=IF(Sheet2!A4<>"",Sheet2!A4,"")

[oliver]

Thanks for the reply XLD, but I couldn?t get your suggestion to work.
I my example, refer to A23, it is the cell containing the link.
What I need is CF in B23 that will 1) have no formatting if A23 has no values visible, 2) format the cell to a color if A23 has a value visible, & 3) clear the formatting if I enter a value in B23.
Hope this makes since, sorry if I am misinterpreting what you suggested.
Thanks, Oliver

[Bob Phillips]

I understand, and I think I have given you a solution whereby you only have to change the formula in A25.

[oliver]

You are correct, my error. It works great.
thanks
Oliver