conditional format - - comparing cells

[huhwhat]

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

[pinmaster]

Hi
You can use conditional formatting. First select your range you want to format then goto Format/Condtional formatting, for the condition select (Formula Is) and type:
=A$5<A$1
and choose your format.


HTH
JG