+ Reply to Thread
Results 1 to 2 of 2

Can't remove Conditional Formatting

  1. #1
    pato
    Guest

    Can't remove Conditional Formatting

    Hi All

    I've downloaded the new Beta2 and was testing some features.
    I selected one cell and gave it a Color Scale from the Conditional
    Formatting. Now has this Cell a nice green color if it's filled with
    something.

    But, how can I remove this again?
    Delete button nor backspace button work, as soon as I type something in
    there again is it filled green.
    I also tested rightclick --> Clear Content, but it's also a no-go.

    Also giving it a "No Fill" or a white fill doesn't work.

    That should maybe be done easier to remove again.

    Thanks,
    Patrick

    ----------------
    This post is a suggestion for Microsoft, and Microsoft responds to the
    suggestions with the most votes. To vote for this suggestion, click the "I
    Agree" button in the message pane. If you do not see the button, follow this
    link to open the suggestion in the Microsoft Web-based Newsreader and then
    click "I Agree" in the message pane.

    http://www.microsoft.com/office/comm...heet.functions

  2. #2
    Registered User
    Join Date
    05-26-2006
    Posts
    3
    Just put the cursor on the cell and follow the below instructions:

    Click on Format

    Click on Conditional Formatting

    The window will pop up with the formatting.

    Click delete

    Check the condition you want to delete (probably condition 1) and hit OK and you're golden.

+ 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