how to set highlight for row/column header

B

broro183

Hi Jasmine,

This may not be exactly what you want but have a look at this page it
shows how to highlight a # of columns on the active row using a
worksheet selection change macro (& will reset the cells' colour when
the active cell is moved:

http://www.mcgimpsey.com/excel/highlightrow.html#HiLiteRetainColor

To use either of the macros shown on above page (save a copy of your
file first)...
Copy the suitable macro, right click on the sheet in excel that you
want to apply it to, choose "view code", paste the macro, & close the
active window to return to Excel.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Highlight active cell with font color? 3
Highlighting row of active cell question 4
Header in row to column 1
Find values across a row and return a text value from the same column 2
Highlighrt a Row 1
If this cell is highlighted, then also highlight these cells 1
How to highlight the lowest valued cell in a column in Excel 2003 2

Top