Mike, this works but the amount is in c3 and I need a3 highlighted if it is
greater than 2499.99. We are using Excel 2007.

Again, thank you for your help.

"Mike H" wrote:

Hi,

use conditional formatting. select A3 then

Format|Conditional formatting -select 'Formula is' and enter this formula

=$C$32499.99

Pick a colour and click OK and your done.

Mike

"Dottie" wrote:

Hi and thanks in advance for your response.

I need a formula that if c3 2499.99 then hightlight a3. Is this possible?