Hi RJJ,

Since the macros take you to sected cells, you can add this to each macro.
If your selected cell on the first macro is A1:
(You can most likely omit the first line since your macro will take you to
the specified cell)

Range("A1").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With

This will add the color Yellow to the cell.

Squeaky

"RJJ" wrote:

I have a macro on sheet (1) that takes me to a specific cell on sheet (2). I
need the now selected cell on sheet(2) to highlight to some color (yellow
probably). The macros on sheet (1) are along side a long list of names. So as
I select the appropriate macro, the appropriate cell needs to highlight on
sheet (2). This workbook will ultimately be placed on a server drive so the
formatting, code, macro or whatever needs to be within the workbook and not
an add-on that is specific to the terminal.