Conditional Formating problem

[doug.sloane]

Hi

I have 2 columns A & B. I want the 2 columns to be blank until something is typed into a cell in column A. Then I want the corresponding cell in column b to be a url such as "http:\www.abc.comsearch=" & A1.content

I'm using the following on the B cell but can't get it to work :
=IF(A1="","",("http://www.abc.com/guestSearch.asp?search=" & A7 &"&name=hello" & A7))

Also if possible I'd like the contents of column B to be protected.

This is fairly urgent (well for me, obviously not for ye lot) so any help would be much appreciated.

 

[Aladin Akyurek]

On 2002-08-06 04:18, doug.sloane wrote:
Hi

I have 2 columns A & B. I want the 2 columns to be blank until something is typed into a cell in column A. Then I want the corresponding cell in column b to be a url such as "http:www.abc.comsearch=" & A1.content

I'm using the following on the B cell but can't get it to work :
=IF(A1="","",("http://www.abc.com/guestSearch.asp?search=" & A7 &"&name=hello" & A7))

Also if possible I'd like the contents of column B to be protected.

This is fairly urgent (well for me, obviously not for ye lot) so any help would be much appreciated.

Have a look at the HYPERLINK worksheet function.

 

[doug.sloane]

How do I include the hyperlink function with the IF function I'm using though ?

 

[Aladin Akyurek]

On 2002-08-06 04:40, doug.sloane wrote:
How do I include the hyperlink function with the IF function I'm using though ?

What is in A7?

 

[doug.sloane]

OK Sorry about that - the A7 reference is misleading. The first part is now working - when you type something in say A1 the URL appears in B1 with the text from A1 included in the address. It's not however appearing as a link that you can click on. When I put the HYPERLINK() around the IF statement it does create a link from B1 but the url does not appear in the cell for some reason.

I appreciate your time on this bythe way.

 

[doug.sloane]

It's working now with :

IF(A1="","",HYPERLINK("http://www.whatever.com/expo/script.asp?search=" & A1 &"&login=snap" & A1))

Thanks

 

[inarbeth]

You can incorporate the HYPERLINK function thus:

=IF(A1="","",HYPERLINK("http://www.abc.com/guestSearch.asp?search=" & A1 &"&name=hello" & A1))

 

[Aladin Akyurek]

On 2002-08-06 06:02, doug.sloane wrote:
OK Sorry about that - the A7 reference is misleading. The first part is now working - when you type something in say A1 the URL appears in B1 with the text from A1 included in the address. It's not however appearing as a link that you can click on. When I put the HYPERLINK() around the IF statement it does create a link from B1 but the url does not appear in the cell for some reason.

I appreciate your time on this bythe way.

Give an example of what can be in A1. And, indicate literally how the link should look like with that value in A1.