Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013. There is text in one cell on the updating tool sheet, i need to search the database sheet for matching text and select it. I would prefer to not use an input box if possible because the text is already automatically entered into the first cell on the updating tool sheet.
Active2 years, 1 month ago
An Excel column contains a text value representing the category of that row.
Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format for each value?
Example: if I had the categories
bedroom, bedroom, bathroom, kitchen, living room , I would want all cells containing bedroom to be a particular color, bathroom a different color, etc.
Steven
Steven
![]()
24k1010 gold badges8181 silver badges110110 bronze badges
4 Answers
17.2k1111 gold badges4646 silver badges9292 bronze badges
EricEric
The screenshots below are from Excel 2010, but should be the same for 2007.
Select the cell and go to
Conditional Formatting | Highlight Cells Rules | Text that Contains
UPDATE: To apply the conditional formatting for the entire worksheet select all cells then apply the Conditional Formatting.
(Click image to enlarge)
Now Just select whatever formatting you want.
karel
9,8911111 gold badges3535 silver badges4141 bronze badges
Nicu ZecheruNicu Zecheru
5,00966 gold badges2828 silver badges4646 bronze badges
From: http://www.mrexcel.com/forum/excel-questions/861678-highlighting-rows-random-colors-if-there-duplicates-one-column.html#post4185738
KarmoKarmo
The automatic color choosing Conditional Formatting is not a feature of Microsoft Excel.
However, you can color an entire row based on the value of a category column individually.
24k1010 gold badges8181 silver badges110110 bronze badges
protected by Community♦Jul 13 '17 at 19:57
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead? Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-2007formattingconditional-formatting or ask your own question.
Active2 years, 6 months ago
Is there a keyboard shortcut key to select all the text in the current cell in Excel, if you are in the process of editing the cell?
Lorin HochsteinLorin Hochstein
1,10944 gold badges1919 silver badges3232 bronze badges
8 Answers
Note that in later versions of Excel, the “Windows” equivalents, made by substituting the alt for control, also work.
![]()
51322 gold badges88 silver badges2121 bronze badges
The quickest way I've found is the following:1) tab/select the cell, 2) hit backspace to delete the contents of the cell3) type Cntrl+Z to undo delete
When the undo function puts the text back into the cell, all text within that cell is automatically highlighted. Then you can just type Cntrl+C to copy text only.
I found that I needed to highlight all text in a cell in order to be able to paste it back inside another excel sheet whose cells already had other text that I had to leave intact.
Hope this helps!
WFrazierWFrazier
The great thing about copying the contents of the cell rather than the cell itself is to grab the contents without any formatting (plain text). It really should have a one-step shortcut, but to my knowledge, it doesn't. Here's my workaround:
Select cell in question, hit any character to replace contents of the cell. Then hit ⌘Z to undo and boom, contents selected without any formatting!
A one-step shortcut workaround will require more effort, but can be achieved with the following Keyboard Maestro macro:
grg♦
145k2525 gold badges229229 silver badges340340 bronze badges
circldcircld
I read this as 2 questions.
Q. Is there a keyboard shortcut key to select all the text in the current cell in Excel?
A. command+c for Mac or control+c for Windows while the cell is selected. Choose a new cell and command+v or control+v to paste.
Q. If you are in the process of editing the cell?
A. It is a two step process, command+a or control+a to select all, then command+c or control+c to copy.
Excel For Mac Select Cells With Containing Specific Textual EvidenceDave NelsonDave Nelson
4,14711 gold badge1111 silver badges1212 bronze badges
When editing a cell, a quick way to select all the contents is to…
Excel For Mac Select Cells With Contain Specific Text Vba♦
145k2525 gold badges229229 silver badges340340 bronze badges
JalaJala
I'm using Windows, and I do this:
Note it doesn't work if you enter the cell by writing on it, you have to edit.
grg♦
145k2525 gold badges229229 silver badges340340 bronze badges
LorenaLorena
Select Cells With Conditional Formatting
Do you want to select all the text, or do you really just want to copy it to the clipboard? If you want to copy all the text in a cell and don't care if it's selected:
Click on a cell or navigate to it using the keyboard. Do not double-click or not enter edit mode. Do not try to select anything. If you are already in edit mode for some reason, hit Esc.
Now just hit CMD-C.
MadReasonableMadReasonable
There is no direct way. Please refer the official page for this.
Use of native methods (go to end, use SHIFT+Arrow keys)... wondering why ^A is not supported there. MS S**ks sometimes.
user44073user44073
How To Select Cells With Text In ExcelYou must log in to answer this question.Excel Select Cells With ValuesNot the answer you're looking for? Browse other questions tagged ms-office .Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |