If you mean you wish the current or active cell to be highlighted then paste
the following code into the Thisworkbook Module.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
On Error Resume Next
Sh.Cells.Interior.ColorIndex = xlColorIndexNone 'xlColorIndexNone
'or -4142
Target.Interior.ColorIndex = 6 ' yellow - change as needed
End Sub

HTH

"vla" wrote in message
...

Hi all,

I'm not very experienced with Excel and I was wondering if it's
possible to set up a rule in a spreadsheet so that the last entry is
highlighted or in a different color.

Does anyone know?

Thanks!
Vla


--
vla
------------------------------------------------------------------------
vla's Profile:
http://www.excelforum.com/member.php...o&userid=31711
View this thread: http://www.excelforum.com/showthread...hreadid=514133