Results 1 to 5 of 5
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Please see the Attached (2003)

    This is essentially the same as the post you deleted.

    In the first place, it is not polite to delete a post that has been replied to - it makes the reply incomprehensible to others reading it. (I have removed that thread)

    In the second place, you shouldn't start a new thread about the same question.

    The following corresponds exactly to the instructions <!profile=mbaney>mbaney<!/profile> gave in the now deleted thread:

    Select cell F3 (the cell to be formatted)
    Select Format | Conditional Formatting...
    Select Formula Is in the first box, and enet =(A3=1) in the second box.
    Click Format...
    Activate the Patterns tab
    Specify the color you want.
    Click OK twice.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Please see the Attached (2003)

    See <!help=08>Help 08<!/help>. If you need to make changes to an existing post, no matter how substantial and even adding an attachment, you can edit your post. Select your post and click the edit button <IMG SRC=http://www.wopr.com/w3timages/edit.gif> on the top right of the post. Edit away, and add or replace an attachment if you need to.

    Also, near the bottom of the post editing window you will see a button which you can use to indicate that you have edited your post, and a pane in which you can enter the reason for the edit. If you use the edit button your post will show with the edited icon <IMG SRC=http://www.wopr.com/w3timages/edited.gif> at the end of the subject, and other Loungers will know that you have edited it.

    I hope this will help you Lounge more effectively. <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Please see the Attached (2003)

    And as an occasional visitor, it would be better to title the thread something like "Conditional Formatting" rather than "Please see the Attachment" (which is not very helpful when browsing).

    Thanks. [img]/forums/images/smilies/smile.gif[/img]

  4. #4
    Lounger
    Join Date
    Dec 2003
    Location
    London, England
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How does conditional formatting work? (2003)

    Please see the attached - Does conditional formatting work ?
    I couldn't get it to !!!!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Please see the Attached (2003)

    Good point. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    I edited the subject of the first post in the thread.

Posting Permissions

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