Need help with a formula

D

Dottie

Hi and thanks in advance for your response.

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

Mike H

Hi,

use conditional formatting. select A3 then

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

=$C$3>2499.99

Pick a colour and click OK and your done.

Mike
 
D

Dottie

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.
 
M

Mike H

I don't know how to do it in 2007, I have 2003

Dottie said:
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.
Click to expand...
 
V

Victor Lobo

I don't know how to do it in 2007, I have 2003
Click to expand...

Hi

In 2003 or 2007 you need to select cell A3 first.

In 2007 then goto Conditional Formatting > New Rule > "Use a
formula..."
Enter the formula =$C$3>2499.99
Pick a color

Hope this helps

Victor
 
Top