Excel macro for row selection
 

Hi,

I was wondering if someone can advice on the following:

I have got spreadsheet with retirement calculations. I want when the in one particular column (name - Contributions); the value goes above $25,000 it should do two things:

1) Highlight that row (any color)

2) Should reduce the value back to $25,000 in that cell and all further cells (after that), only in that particular column.

Thanks in advance.