Hi !



What I'm trying to do is find a macro (or any other way that works) that will automatically compare two numerical values (cells) in a row, and then change the background color of that row based upon the result of the comparison. i.e. On a financial statement, I want to compare budgeted sales (cell A1) vs actual sales (cell A5) and highlight the row (cells A1 - A15) red if A5 is less than A1. Hopefully, this can be coded so that I can individually compare all 300+ rows on my financial statement.

This must be a really obvious thing, but I just haven't been able to figure it out yet.

Thanks for your help!
Rick