Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Conditional formatting 2007

    Hi there
    I have a simple question that just doesn't seem to work in excel 2007.
    In column B I have 2 words - either Show or Hide..
    When it is "Hide" the rest of the row turns into white font.

    When it is "Show" you can see the writing. Simple and effective. However, I struggle with the new conditional formatting feautre of 2007.

    I've done it before rather successfully in 2003.

    Anyway help!!!

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi

    Yes it is not as easy as it used to be.

    So, lets start with the Hide rule:
    Lets start with row4 as an example.

    Click the row number 4 on the left-edge to select and highlight the entire row.
    Now from the Home tab in the top panel ribbon, select Conditional Formatting in the Styles section, and then Manage Rules from the displayed list (at bottom of menu list).
    Click [New Rule].
    From Select a Rule Type: pick >Use a formula to determine which cells to format.
    In the box under where it says Format values where this formula is true: enter this:
    =$B4="Hide"
    Then click the [Format] button (bottom right corner) and set the Font colour to white (the Preview won't show anything of course!).
    Click [OK] button to finish.
    Now select cell [B4], then, in the [Home] tab in the top-panel ribbon, click the Clear dropdown in the Editing section (right-hand edge of the Home ribbon), and select Clear Formats.
    (You need to do this, otherwise the word Hide will disappear also in column B)
    Now that we have set this format for row4, simply select and highlight this entire row and use Paste Formats to other required rows.

    Use same method for other required format.

    zeddy

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Taranaki, New Zealand
    Posts
    193
    Thanks
    3
    Thanked 0 Times in 0 Posts
    WOW thanks...

Posting Permissions

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