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/highl...iteRetainColor

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...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=508841