Assign a hoykey combination to a macro, containing these 2 lines of code:
__________________________________________________ ____________________
ActiveCell.Value = ActiveCell.Value & " < 10.000"
Range(ActiveCell.Row & ":" & ActiveCell.Row).Interior.ColorIndex = 6
__________________________________________________ ____________________

CE


ActiveCell.Value =
"jjnotme" wrote in message
...
I want to be able to add words to the end of a cell. For instance if
the cell contains "total for NY", I want to be able to add " < 10,000"
at the end. The cell would need to say "total for NY < 10,000". Then
I want the whole row highlighted in yellow.
Can someone please help me with this?
Thank you
CP