help help help IF function
 

i am new to excell and need help with a problem...... the problem is iam
looking for a amount < = 3000.00 and iam to display in bold and in light
green i have never had to deal with that i got as far as

=IF<=3000 then iam lost or it that even right??

help help help IF function
 

I'm far from a whiz at Excel but I'd use conditional formatting.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"kimmy" wrote in message
...
i am new to excell and need help with a problem...... the problem is iam
looking for a amount < = 3000.00 and iam to display in bold and in light
green i have never had to deal with that i got as far as

=IF<=3000 then iam lost or it that even right??

help help help IF function
 

Try this:

Select the cells to be impacted

Then...from the Excel main menu:
<format<conditional formatting
Cell Value is: Less than or equal to: 3000
Click the [format] button and set the format you want.
Click the [OK] buttons and you're done

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"kimmy" wrote:

i am new to excell and need help with a problem...... the problem is iam
looking for a amount < = 3000.00 and iam to display in bold and in light
green i have never had to deal with that i got as far as

=IF<=3000 then iam lost or it that even right??

help help help IF function
 

IF(Cell#<=3000,DoSomething,<DoSomethingElse)

"kimmy" wrote:

i am new to excell and need help with a problem...... the problem is iam
looking for a amount < = 3000.00 and iam to display in bold and in light
green i have never had to deal with that i got as far as

=IF<=3000 then iam lost or it that even right??