Free Microsoft Excel 2013 Quick Reference

selecting highlighted cells

Is there a function that allows you to select all cells that have a certain
format (for example, all cells that are highlighted yellow)?


Post your answer or comment

comments powered by Disqus
Dear Reader,

I'm trying to create a macro in Excel (for windows XP) which adds a certain
number of selected cells, for example 7 in a vertical direction, to a
selection of cells which are already highlighted before the button was
pressed. If there is no way using macros, then please could you offer me a
solution within another program?

Please note, I'm very new to coding/programming and understand very little
of the te technical jargon. I have read through the help files for all of
excel and all of visual basic, but find no solution directly. Please could
you take the time to go through any ideas you have with me by E-mail or other
contact as I am in great need of completing my project as soon as is possible.

Please note that my E-mail address has changed to:

Dear Reader,

I'm trying to create a macro in Excel (for windows XP) which adds a certain
number of selected cells, for example 7 in a vertical direction, to a
selection of cells which are already highlighted before the button was
pressed. If there is no way using macros, then please could you offer me a
solution within another program?

Please note, I'm very new to coding/programming and understand very little
of the te technical jargon. I have read through the help files for all of
excel and all of visual basic, but find no solution directly. Please could
you take the time to go through any ideas you have with me by E-mail or other
contact as I am in great need of completing my project as soon as is possible.

Please note that my E-mail address has changed to:

EdWardleDavies@Gmail.com

Thank you for your time and attention.

Yours Sincerely,

Ed

Hello,

I don't know if the Title provided is correct or not. Please accept my apology if it is not.

I would like to select a cell inside my workbook and when it is selected it automatically highlights similar value cells in the same workbook. Is that possible?

A Look at the attachment should give you a much better idea as to what I am talking about.

Regards,

Chimero

When you select individual cells with CTRL+mouse click; How do you get each cell to be HIGHLIGHTED (same color on each click) just like it did in ALL previous version of MS Office (2003, 2000, etc)?

The only things being highlighted in 2007 version, are the end borders of the row where each cell is located and the top of the column.

It is very difficult to look back and see all the individual cells that you just selected (especially in multiple columns selection with same row of cells selected). The NEW 2007 MS Office no longer perform this highlighting action by default. o/

When I select multiple cells in a spreadsheet that are not adjacent to each
other, I can't see what cells are being highlighted unless I go through the
extra step of changing the cell colors. Sometimes, I want to quickly add up
multiple cells by simply highlighting them. I can't do that unless I change
the color or write in a sum function. For example, if I click on cells A1
and C10 and d25 to add them up, I can only see that my cursor is on the last
clicked cell, so I can't tell if I've highlighted all three cells. It's
driving me crazy and slowing me down. Any thoughts?

Does anybody know if it is possible to change the colour and or contrast of
the cell selection highlight colour. This is where you wish to highlight
cells but not change thier colours in the spreadsheet. The highlight colour
contrast I am seeing on screen is too light. It makes no difference if I
change the vdu contrast and brightness settings.

I have a vba macro which defines a range such as below:

What i want to do is highlight this range "rngSourceData" so that i can see what cells make up this range.......but
i keep getting an error .

Any ideas how to select/highlight this range?

In excel 2003, when I select a cell on any row, it results in having a check mark placed in the cell on my "J" column of that same row. I am
hoping to have all selected cells, including the checked cell, highligted in
yellow and have the data underlined in the cells. But the Checked cell need
not be underlined just checked and highlighted in yellow. Ultimately I'd
like to be able to do this with my stylist pen. Is this doable and can you
help me out with doing this? thank you in advance

if i select a cell (example b2) how can i get excel to highlight row b

any suggestions?

We would like to highlight a range of cells, for example G12:I30. Then we want to use the Shortcut: Ctrl+Shift+R to select cell A30 ( Column A - the last row in the range).

We normally have to type information in a form that could be filled automatically if we could figure out how to select specific cells in a highlighted range.

As always - thanks in advance.

I have a large report with lots of data in many columns and rows. Let's say that I have a customer name in cell A2 and 15 columns to the right I have a value (Cell O2). To make this data more readable I would like cell A1 to show a background color when I select cell O1 and when I move to a another cell the color should disappear.

An alternative would be to have the entire row to to be highlighted when selecting a cell in that row. But the first alterantive is to be preferred.

Any support/suggestions in this matter is highly appreciated.

Regards,
Niklas

Financial Analyst
Using:
Excel 2003, Windows XP

I am trying to highlight cells based on multiple values of the cell itself and multiple values of another cell. For example, cell L5 has a list of three words (emergency, urgent, routine) and I want to highlight E5 red if emergency is selected and E5 has a value of more than 2 (days). E5 has a formula to return the number of days elapsed from two other cells. Then if urgent is selected from L5, and E5 is greater than 14, highlight E5 red. Same with routine if E5 is greater than 365. If E5 is less than those numbers, highlight in green. I have to do this for E5 and L5 thru E632 thru L632. Any help would be greatly appreciated.

Hello, I am trying to highlight cells based on multiple values of the cell itself and multiple values of another cell. For example, cell L5 has a list of three words (emergency, urgent, routine) and I want to highlight E5 red if emergency is selected and E5 has a value of more than 2 (days). E5 shows the number of days elapsed from two other cells. Then, if urgent is selected from L5, and E5 is greater than 14, highlight E5 red. Same with routine if E5 is greater than 365. If E5 is less than those numbers, highlight in green. I have to do this for E5 and L5 thru E632 thru L632. Any help would be greatly appreciated.

Hi,

I have strange problem with my excel today. I am not able to select the cells in the worksheet. even if i try to copy a range of cells and move the mouse over it , i cant see blue hightlighting color, however, when i hit ctrl+c, that range is getting highlighted.
Please help me

Regards,

Nik

Hi everyone. I have a worksheet where I first filtered, then hid some columns. Used to be that I just highlighted the area I wanted copied, clicked the select visible cells button that I put on my toolbar, ctrl c and ctrl v into a new worksheet and only the visible cells would be copied. Now the button isn't working because when I ctrl v into the new worksheet, it shows the hidden columns also. Anyone have any ideas? Seems like such a simple task but I can't figure it out. I even removed the button from the toolbar and put it back on but still doesn't work.

Hi Experts,

I have two xls files. The "data.xls" contains the 2 columns (A & B) list with N numbers of rows. The "report.xls" is having blank format containing 2 columns and only 10 rows to acomodated top 10 data.

The certain cells in column "B" of "data.xls" is highlighted using color which needs to be ignored while preparing the report.

The macro should acsending short the "data.xls" and then copy the 10 rows in "report.xls" by avoiding rows for which cells in column "B" of "data.xls" is highlighted using color.

I have tried using the following code, but in case of one highlighted cell, the 9 rows only copied to report file. if i highlight 2 cells, only 8 rows copied to report file. I need 10 rows in the report.

Thanks...

Sub PI()
'
'
'
Dim srnofrm As Long, srnoto As Long
Dim repf As String, dataf As String
pastpos = 10
srnofrm = 1
srnoto = 10
Windows("Data.xls").Activate
dataf = "Sheet" & Sht
Sheets(dataf).Select
Columns("A : D").Select
Selection.Sort Key1:=Range("B1"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
For srno = srnofrm To srnoto
Windows("Data.xls").Activate
dataf = "Sheet" & Sht
Sheets(dataf).Select
If Range("B" & srno).Interior.ColorIndex 6 Then
Range("A" & srno & ":B" & srno).Select
Selection.Copy
Windows("TOP_PI.xls").Activate
repf = "Sheet " & Sht
Sheets(repf).Select
Range("B" & pastpos).Select
ActiveSheet.Paste
pastpos = pastpos + 1
Else
srnoto = srnoto + 1
End If
Next srno
End Sub

Version: XP SP2 / Excel 2003

I want to copy a range of cells and paste them elsewhere on the sheet. But the range will be different every time, highlighted by selecting the cells, then starting the code.

The Activecell command works successfully with one cell. But I can't seem to work it out between the Offset command or ActiveRange(?).

Any help would be greatly appreciated.

...>

Hey I don't know what I did but i selected a cell and now it wont delselect it when i try select a different cell it selects all the cells from that to the other cell creating a rectangle that is highlighted

I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I
first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then
highlight the cells I wish to protect, repeat that step, only this time make
sure the LOCKED check box is checked.
I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the
option, and JUST the option for "Select locked cells", however, everytime I
select this option, a checkmark appears next to "Select unlocked cells" as
well. One seems to trigger the other. The net effect is that the WHOLE
worksheet becomes locked instead of just the protected cells.
Has anyone else experienced this problem and/or know of a solution?

Thankyou

Currently when I select multiple cells with my cursor the "highlighted" color
is very faint. It's nearly impossible for me to see especially if there is a
glare on my screen. Is there a way to make the shading darker when I select
multiple cells so I can see what I've selected?

Ryan responded with this code to highlight the cells. What code would delete
the rows?
------------------------
So you just want to "Select" the cell? Use this,

Sub Highlighter()

Dim lngLastRow As Long
Dim rng As Range

lngLastRow = Cells(Rows.Count, "D").End(xlUp).Row

For Each rng In Range("D1" & lngLastRow)
If IsEmpty(rng) Then
rng.Select
Exit For
End If
Next rng

End Sub
--
Cheers,
Ryan

--
Mickey

Hello,

each month i have to clens a sheet that shows customer name and then the figures per month.

this is pulled from a system that allows for a new entry each time a variation on customer name is used, I.E

Joe Blogs LTD
Joe Blogs Limited
Joe Blogs ltd.

would all come through as new entries.

then i have to manually consolidate the figures from each month.

the spreadsheet has over 5000 rows, and maybe only 15% are duplicated.

what i want is to be able to select the column (that will be sorted a-z) and highlight cells that have a match for the first 4 or 5 charicters.

once i have identified duplicates i then have to merge the data into one row.
is there an easy way to do this?
it is monthly, comparing 2008 and 2009, so by december there will be 24 columns + the company name that need to be clensed.

any help would be much appreciated.

I'm trying to highlight a bunch of cells in clusters not close together, and then invert the selection so that all cells BUT these are selected (therefore capturing all possible cells that someone could scroll to). In XL03 you could go to File > Invert Selection and it would work fine. But in XL07 which I have now, there doesn't seem to be a way to do it. Also, when using ctrl^a to highlight everything, and while still holding control in XL03 you could de-select specific cells, not so much in 07. I need to know if there's a way to do it with no macros involved. If not, I need a macro to do such a function on any given worksheet. Thanks!

I have a range of formatted cells and I want to highlight them... make them
stand out, but without changing the color scheme. I want to be able to select
multple cells of multiple colors and click a HIGHLIGHT button and have the
brightness increase in each cell... so dark blue becomes slightly dark blue,
dark red become slightly dark red, green become slightly bright green... etc.


No luck finding an answer? You could always try Google.