Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pato
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrExcelWannaB
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping conditional formatting when sorting Andrea A Excel Discussion (Misc queries) 0 April 4th 06 03:00 PM
conditional formatting Rich Excel Discussion (Misc queries) 2 April 1st 06 10:27 AM
cannot use ISEVEN or ISODD functions in Conditional Formatting Scott Paine Excel Worksheet Functions 6 December 6th 05 09:44 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
conditional formatting conflict? Abi Excel Worksheet Functions 2 January 11th 05 03:41 PM


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"