Results 1 to 8 of 8

Conditional Formating problem

This is a discussion on Conditional Formating problem within the Excel Questions forums, part of the Question Forums category; Hi I have 2 columns A & B. I want the 2 columns to be blank until something is typed ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Posts
    13

    Default

    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.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default

    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.

  3. #3
    New Member
    Join Date
    Jun 2002
    Posts
    13

    Default

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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default

    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?

  5. #5
    New Member
    Join Date
    Jun 2002
    Posts
    13

    Default

    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.


  6. #6
    New Member
    Join Date
    Jun 2002
    Posts
    13

    Default

    It's working now with :

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

    Thanks

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    906

    Default

    You can incorporate the HYPERLINK function thus:

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

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    61,998

    Default

    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.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com