Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't remove Conditional Formatting
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. -- MrExcelWannaB ------------------------------------------------------------------------ MrExcelWannaB's Profile: http://www.excelforum.com/member.php...o&userid=34842 View this thread: http://www.excelforum.com/showthread...hreadid=545880 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions |