Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Highlight Row And Column

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

As I move down a cell, I would like the entire row and column be highlighted. Is that possible?

View Answers     

Similar Excel Tutorials

Highlight Rows that Meet a Certain Condition in Excel
In this tutorial I am going to cover how to highlight rows that meet a certain condition. To do this I use the Cond ...
Easily Compare Duplicate Values in Excel
Here, I'll show you a simple technique to quickly and easily compare large lists of duplicate values.á This allows ...
Display Comments (without hunting for them) - Excel 2003
To find options, go to the File menu, then click options, then click advanced and click on comments and indications ...
Rename a Module for an Excel Macro
This Excel tip shows you how to rename a module in Excel. This is a very important thing to do when you have a larg ...

Helpful Excel Macros

Highlight the Column of the Selected Cell
- This macro will highlight the column of the active cell. This will fill the column of the active cell with a solid back
Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active cell w
Highlight the Row of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the row of the active cell with a solid
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.
Highlight Cells with Text or Formulas (non-empty cells)
- This macro will highlight all cells in excel which are not empty. This means that if a cell contains formulas, text, nu

Similar Topics

hai guys

i have got a large amount of data in a sheet which i found it difficult to compare with the other columns
usually when ever we place our cursor in a particular cell ,only that cell will get highlighted by default
what i want is THE ENTIRE ROW SHOULD GET AUTOMATICALLY HIGHLIGHTED when we even place the cursor in any one of that row cell
than is should disappear when we move the cursor but wherever we move the cursor that particular entire row
should be again highlighted.

Thanks guys

G'day all,
I spend a lot of time in spread sheets working with part numbers and sales figures. With a part # in column B and sales per month in adjacent columns, stretching back years. Is there any way to highlight an entire row automatically? ie. I use Ctrl F to search for a number and it goes to B24. I now want the entire row 24 highlighted as the active row. When I move to another cell I want the entire row highlighted automatically. Can it be done. Hey, no prizes for guessing I'm pretty backward when it comes to this stuff.

Hi I am a completely new to VBA and have a question.

Is there any way to create a formula that will either highlight (in red lets say) an entire row, or move the entire row to another worksheet, if one cell has "Y" in it. Moving the entire row would be preferable.

I have been able to highlight the one cell, but I need to either highlight the entire row, or move it completely, and this seems to be way beyond my capabilities.

Any help would be much appreciated.

I am trying to Highlight an entire row, if a vlue exists within a column. I have read many forums in which you can create a macro to do this. I have "10" values that I would like to use as far as values within a column. I would like to run the macro, and if a number exists, I would like it to highlight the entire row.
The cells that i would like to have read are within Columns "w" and "x". The cell values are within a merged cell because of the way that the program exports the report into excel.

The values that I would like to have met are :

96- Highlight Entire Row Orange
237-Highlight Entire Row Yellow
402-Highlight Entire Row Blue
680-Highlight Entire Row Blue
871-Highlight Entire Row Blue
827-Highlight Entire Row Blue
213-Highlight Entire Row Blue
833-Highlight Entire Row Blue
339-Highlight Entire Row Blue

Please let me know If I can post the excel spreadsheet, and whether or not I can be helped. Thanks !

Hi there,

My version of excel only contains options to add 3 conditional highlights, however, I require 6 conditional highlights to ideally perform a specific task. Is there anyway of achieving the following, perhaps via a macro???

If a specific word is typed into cell AG2, the entire row 2 will be highlighted in a specific colour including cell AG2 according to this order:

paid = green highlight
sol = pink highlight
hold = red
temp = yellow highlight
gen = orange highlight
call = blue

Please note that I wish the formulae to function through the entire column AG from cell AG2 onward. Row 1 contains headers. So if, for example, a word indicated above is typed into AG3, then the entire row 3 will be highlighted with the corresponding highlight.

Your help in this matter is most appreciated.

Kind regards,


as records in excel increase, its hard for us to know which rows we are
selected or referring to..for example column(A) to column(Z) in row 10
it will be easier if the selected row(10) is highlighted the moment we move
to row10
to edit any column ...
wonder if i can do that ?

when u move out from row10, maybe to row 15...then row 15 will be
highlighted next..
the moment we move to whichever row, that particular row is to be

can it be done ? thanks...

I have a long spreadsheet with info through column AT and Rows through 22. In Column S I want to input Conditional Formatting that will highlight the entire row of cells with yellow fill if my drop down menu in Column S is "Yes". So far I have only been able to formulate the Conditional Formatting to highlight the particular cell in Column S when "Yes" is displayed, not the entire Row. Does anyone know how to Conditionally Format an entire Row to be highlighted if a cell in that row displays certain info? Any responses are greatly appreciated! Thanks.

I have checked everywhere and have been unable to locate an answer to this question. I want to be able to highlight the row that my cursor is currently in. For instance, if I am in cell G11, then I want row 11 to be highlighted. As I move to another cell, say F21, then I want the highlight to move with me so that row 21 is highlighted. Please help!!!

Hi folks,

I'd appreciate any help on this as I am a novice and really don't want to do this manually!

I have a spreadsheet with over 100 rows and 100 columns. I want to highlight any columns which contain the exact same values. The entire column needs to be identical to the other highlighted column. So for example:

If Column A is the exact same as Column B and Column D then highlight all of the columns in orange.
If Column F and Column C contain the same values then highlight all of the columns in brown.
If Column G does not have a match then don't highlight.

An example of what I mean is attached.

Thanks for any help,

Does anyone know how to highlight an entire row and column automatically when the cursor activates a cell in a spreadsheet?

I have a large spreadsheet and when I click on a cell I'd like the whole row to be highlighted so I can check that I'm editing in the correct row. I know that the ROW HEADER is highlighted but I'd like the entire row to be highlighted. I'd like this to be so for every cell on my spreadsheet.

Any help would be appreciated.

Cheers, John

Hello, I've a question. I'm working with two worksheets here. I wrote a macro for worksheet1 that colors a a cell red when a certain condition is met.

If a cell is colored red, it will go to the cell in the same row but in column A and highlight that as well. So for example, if cell D12 is highlighted red, then also D1 will be red, if cell E55 is highlighted red, E1 will be highlighted red as well.

What I'd like to do is create a macro that will go through all the cells in column 1, if any of those cells are red AND if the macro could find that particular value in worksheet2, to highlight that entire row red. For example, if D1 is red in worksheet1 and if the corresponding value of D1 could be found in any cell of column A of worksheet2 then highlight that row red. So if the value of D1 was found in cell G1 of worksheet2, row G would be red.

Is there an effective way to write a macro for this? Thanks in advance.

Hi Guys,

Is there a way to highlight an entire row, if a cell value in a column equals 1?

Basically I have a column full of 1's and 0's. If the cell value in the column is 1 I want the row to be highlighted green?

Or is this more of a VBA task?

i can not see the found cell in a highlighted column when using Ctrl F. I'm using Windows XP, Microsoft Office 2007 Professional. When I highlight a column, the highlighted color is so light that when I do a "Find" CTrl+F command and it finds the value I can't see where the value is highlighted. Is there any way I can darken the highlight used when selecting the range in which you want to search?I Changing the color scheme for the entire program doesn't help. I have resorted to doing a Find All for the moment. Any other ideas

Hello Guys,Gals.

For sometime now i've been searching how i could highlight entire rows in excel based on the data in one column. like for example
----A--- B--- C--- D--- E

i made a formula that highlights the last occurance of the duplicates in a column. therefore A2,A4,A5 and A6 will be highlighted. A5 and A6 are highlighted even though it has only one occurance which is exactly what im looking for the conditional formatting to do.

the folmula i used in conditional formatting is


Now iam limited to highlighting only one column. Can anyone help mewith highlighting the entire row of the cells that are already highlighted?

Thanx for all the help in advance

Is there a way to have Excel highlight the row and column in a "Cross-bar"
fashion, that is dependent on the current selected cell?

This would be very useful when one needs to read data in a few cells near a
selected cell barried in the middle of a dense dataset. Especially, when you
are taking your eyes on and off the screen and have to move the selected cell
at every step. For example, when I move the selection onto cell "G19", the
entire row 19 and column G would be highlighted such you get a big
highlighting cross "+" that extends to ±infinity in the respective row and
column of the selection, such that data a few cells above or below or a few
cell besides the selected cell position can easily be read.

Perhaps anyone has seen a utility or function that allows this? If anyone
has an idea how this could be implemented in VBA, let me know.

I have been given a sheet with a few thousand rows that I'm having to look at row by row and make changes to the content as needed.

As I navigate down, of course the cell in the column in question is highlighted, but is there a way to have the whole row highlighted when I move to the next cell up or down? This would help because there's information in other cells along each row that I need to see to populate the cells in the column in question.

I found a chunk of VBA code that will come close to doing what I need, but it only highlights the row from A to where the cursor is, and I'd like the whole row highlighted (the sheet in question goes to column AA).

I know I can hide columns I don't need, and I know I can apply conditional formatting to achieve the old-school greenbar paper look which would help. Just checking to see whether there's some quick setting that would change the display of the current cell to include its entire row as I navigate around the sheet.


Is it possible for cell A1 (my header row) to get highlighted with any color whenever any cell in column "A" is selected.. if I select any cell in column "B" then the highlight should move to B1 etc etc...

Ladies and Gentlemen, I have been repeating these steps for years and to think that now then I look for help, really wasted.

Anyway, I would like to create a macro or something similar to it so that I can have excel handle the steps.

These are the steps that I have been doing :

1) Select a field (entire 1 row ONLY) to search data in

2) Ctrl + F and key in the data I want to locate

3) After cursor moved to the found data, I will move the cursor 4 cells to the right (press 4 x right arrow)

4) Highlight the entire column (Alt + Spacebar) and setup autofilter (filter only 1 column)

5) From filter, choose "Custom" -> "does not equal to" and input zero as data and execute the filter.

6) At this point of time, the entire column is still highlighted, I will Ctrl+C to copy it

7) Open another spreadsheet, with cursor at E1, right click and "Paste Special" -> "Value" -> "Subtract" and hit enter to paste data with reverse value

8) Go back to the previous spreadsheet (the filter is still active at previous column), highlight entire Column A, Ctrl+C to copy it

9) Move back to preceeding spreadsheet, with cursor at D1, right click and "Paste Special" -> "Value" and hit enter to paste value

I have a column of names with a conditional format to highlight that names based on a condition. Now that the names are highlighted, is there a way to separate those highlighted names to work with those only. Either group them all together so I can then copy them or sort by highlight or move highlighted names to another column.

Any help would be greatly appreciated.

Thank you

I am trying to perform an operation on a column. I want to say something so each row of this column is evaluated in character length. If any row apart of this column has a character length less than 6, I want the entire row highlighted. Then move down to the next row and check that one. Until complete. How can I do this? I am using ms excel 07. Everything here is new. I can't find a thing.

The file is too big to do this manually.

I am trying to write a macro that uses conditional formatting on my data (which is columns A to AE wide, and varying rows deep) to highlight an entire row (from A to AE) if there is a cell in the row which is highlighted.

ie. I have conditional formatting set on different columns to highlight cells with errors and cells that are blank. What I would like is to have the entire row highlighted if highlighting already occurs on a cell in that row.

Is there an easy way to do this?


I got a nice bit of code back in the old excel 2003 days about this but I lost it since i changed to 2007, here is the description:

On whatever row I select a cell, make that entire row highlighted with a color or somthing.

Just that simple. I want to click on a cell and make the entire row highlight automatically. If I click another cell, the highligh needs to follow. If I ress the down or up arrow, the highlight just follows theselected cell whereve it goes highlighting the entire row


If I highlight the text I want to move to a different sheet it works fine. See the attached spreadsheet. What I want is to have the macro find "Closed" which will only and always exist in the 'D' column. Highlight the three cells to the right, or can be the entire line, does not matter as there is only four columns of data and move it to 'Sheet 2'. Like I said if I highlight the rows I want and run my macro they move, I just don't want to have to highlight anything as this is going to be embedded into another macro and there is over 1000 rows of data.

Any help would be appreciated.

Hi all,

I'm trying to set up a worksheet so a running total is kept. I want the current total to be highlighted yellow. For example, in D1 I will have 2, in E1 I will keep the total of the D's. So in E1 it will be 2. As this is the first entry it will be highlighted yellow. When the user then enters a value in D2, ie 4, E2 will update to 6. I want then E2 to be highlighted yellow and E1 to have no highlight. When the user updates D3 to say 6, E3 will become 12 and it will then be highlighted and E2 will lose its highlight.

I set up a conditional format condition, for example, for cell E2......

Condition 1: Cell Value is Greater Than E1....highlight yellow.
Condition 2: Cell Value is Less Than E3.....highlight is removed.

However, this isn't working. The cells will highlight yellow but when another value is added to column D and a new total is displayed in E they just keep highlighting, the previous ones do not go back to white.

Does anyone have any I doing something wrong?

Thanks in advance

The problem is: selecting a depth of blank column using a previously filled column next to it so that the blank column is the same length (depth) as the column next to it in a simple fashion. In the good old days of Lotus 123, if we had a column(A) with consecutive numbers going down let's say 20 rows, we could highlight both the (A) column and the blank (B) column right next to it and then select [end down] and then both columns would be highlighted down to the 20th row. We would then just move our cursor to the blank column(B) and then do what we needed with the highlighted (20 row) blank column. In effect, we used the depth of the numbered column to highlight and get to the bottom (equal position) of the blank column. It worked like a charm. How does one do this in a simple fashion in Excel?