| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a formula
Hi and thanks in advance for your response.
I need a formula that if c3 2499.99 then hightlight a3. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
I don't know how to do it in 2007, I have 2003
"Dottie" wrote: 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
On Jan 16, 8:53*pm, Mike H wrote:
I don't know how to do it in 2007, I have 2003 "Dottie" wrote: 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? 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$32499.99 Pick a color Hope this helps Victor |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with a formula
Victor, thank you, thank you. I wasn't clicking on cell a3.
"Victor Lobo" wrote: On Jan 16, 8:53 pm, Mike H wrote: I don't know how to do it in 2007, I have 2003 "Dottie" wrote: 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? 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$32499.99 Pick a color Hope this helps Victor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
