Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Format (2000)

    I have a column U that has contact Name. I want to put "Benefits Administrator" if the a cell in that column does not have a contact name - in other words is blank. How would I set up the conditional format to do this? Thanks for your help.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Format (2000)

    You can't do this with conditional formatting. You could only do it with a macro, though triggering it might be an issue.

    You might create a new column to use as the official "Contact name"
    In U could be the "entered contact name" and in the other you could use a formula like:
    <pre>=if(isblank(U2),"Benefits Administrator", U2)</pre>


    Steve

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format (2000)

    The formula doesn't work unless I press delete in the blank cell in column U. It looks like the cell is blank but there must be something in it. How do I make the blank cells appear blank without going down the whole column and pressing delete in the blank cells?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Format (2000)

    If it has something in it, then it is not blank <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Try this formula:
    <pre>=if(trim(U2)="","Benefits Administrator", U2)</pre>


    Steve

Posting Permissions

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