Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Question
Greetings!
I am using Windows 7 and Excel 2007. In Column A I have numerous cells which contain a certain special "word": let's say the special word is QXT. (The cells contain other words, of course.) I selected the column, click on Conditional Formatting / Highlight Cell Rules / Text that Contains ... Then I typed in the "Format cells that contain the text:" QXT with "Light Red Fill with Dark Red Text" then I clicked OK. Now I would like to delete ONLY all the cells which are now Conditionally Formatted (with the red fill and dark red text). How do I do this? I am still a newbie, so could you please explain in easy, step-by-step English? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Question
I think you will have to use an autofilter on just that column to show the
cells that contain "QXT" in that column. Select those cells and "Delete" Gord Dibben MS Excel MVP On Tue, 12 Jan 2010 16:40:02 -0800, Rebecca wrote: Greetings! I am using Windows 7 and Excel 2007. In Column A I have numerous cells which contain a certain special "word": let's say the special word is QXT. (The cells contain other words, of course.) I selected the column, click on Conditional Formatting / Highlight Cell Rules / Text that Contains ... Then I typed in the "Format cells that contain the text:" QXT with "Light Red Fill with Dark Red Text" then I clicked OK. Now I would like to delete ONLY all the cells which are now Conditionally Formatted (with the red fill and dark red text). How do I do this? I am still a newbie, so could you please explain in easy, step-by-step English? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Question
Try this in your duplicate copy.
Place the cursor in Header Row (i.e. row 1) and press Alt+D+F+F which will apply the filter for your data and now select the column which is formatted as Red Text colour using Conditional Formatting. Press the drop down and select Filter by Colour. In filter by colour drop down you can see the colours which are all applied in the present column text. Select the Dark Red Text colour and press ok. Now it will show only the data which is formatted as Dark Red Colour Text. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Rebecca" wrote: Greetings! I am using Windows 7 and Excel 2007. In Column A I have numerous cells which contain a certain special "word": let's say the special word is QXT. (The cells contain other words, of course.) I selected the column, click on Conditional Formatting / Highlight Cell Rules / Text that Contains ... Then I typed in the "Format cells that contain the text:" QXT with "Light Red Fill with Dark Red Text" then I clicked OK. Now I would like to delete ONLY all the cells which are now Conditionally Formatted (with the red fill and dark red text). How do I do this? I am still a newbie, so could you please explain in easy, step-by-step English? Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Question
Cool.
I'm still getting used to 2007 and forgot about the "Filter by Color" Gord On Tue, 12 Jan 2010 18:14:01 -0800, Ms-Exl-Learner wrote: Try this in your duplicate copy. Place the cursor in Header Row (i.e. row 1) and press Alt+D+F+F which will apply the filter for your data and now select the column which is formatted as Red Text colour using Conditional Formatting. Press the drop down and select Filter by Colour. In filter by colour drop down you can see the colours which are all applied in the present column text. Select the Dark Red Text colour and press ok. Now it will show only the data which is formatted as Dark Red Colour Text. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Rebecca" wrote: Greetings! I am using Windows 7 and Excel 2007. In Column A I have numerous cells which contain a certain special "word": let's say the special word is QXT. (The cells contain other words, of course.) I selected the column, click on Conditional Formatting / Highlight Cell Rules / Text that Contains ... Then I typed in the "Format cells that contain the text:" QXT with "Light Red Fill with Dark Red Text" then I clicked OK. Now I would like to delete ONLY all the cells which are now Conditionally Formatted (with the red fill and dark red text). How do I do this? I am still a newbie, so could you please explain in easy, step-by-step English? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting: Question | Excel Discussion (Misc queries) | |||
Conditional formatting question | Excel Discussion (Misc queries) |