+ Reply to Thread
Results 1 to 2 of 2

Change default checkbox output true false into text

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Bristol, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Change default checkbox output true false into text

    Dear Forum members,

    I am in need of help with a small project I am working on. I'm a novice when it comes to working on excel and I think this is quite a basic answer, so sorry if this is a dumb question.

    Basically, I have inserted checkboxes into my referral spreadsheet. My customers choose the service they require, in this case a diagnostic service (MRI, CT scan, etc), using the excel referral form and then attached the relevant information relating to the medical scan.

    It has become apparent that the customers are not attaching the medical reports on sending their referrals which is causing significant delays in us being able to process the request/ scan.

    I would therefore like to add a checkbox to the form. When this checkbox is 'checked' I want a bold red underlined large font to appear in another cell on the excel document stating, ''If you are referring for a diagnostic scan please attached the relevant report''.

    I've managed to get the checkbox inserted on the form and linked the checkbox to a cell but when I check the checkbox it shows 'true' and uncheck 'false'. I have no idea how to change the 'true' - checked to ''If you are referring for a diagnostic scan please attached the relevant report'' and the 'false' - unchecked to a blank cell.

    Can you help me please?

    Kind regards

    Sebastian

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Change default checkbox output true false into text

    In order to test the checkbox you must have it linked to a cell, which can be any cell you choose, including a cell on another sheet if you want.

    In the cell in which you want to display the message use this formula

    =IF(A1=TRUE,"If you are referring for a diagnostic scan please attached the relevant report","")

    Change the reference to A1 to which ever cell is linked to the checkbox

    Set your conditional format for the message cell to show bold red underlined text when the cell is not equal to a blank
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1