Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is this
possible to do with an IF statement?

Thanks,

Tracy

Conditional formatting.

Select the cells.
FormatConditional Formatting.
Change the dropdown to less than, and 1 in the value box
Click format, select Pattern, select red
OK
OK

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tracy D" <Tracy wrote in message
...
Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is
this
possible to do with an IF statement?

Thanks,

Tracy

No, not possible with an IF statement, but you should take a look at
conditional formatting under Format


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=558643

You should have a look at conditional formatting

"Tracy D" wrote:

Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is this
possible to do with an IF statement?

Thanks,

Tracy

Hi thanks for the help.

I actually would like to first look up a seperate cell and see if that is
less than one or not and then make a different cell red if it is. I was
hoping to use an IF statement but am not sure how to incorporate fomatting.
Any help is greatly appreciated!

Tracy

"Tracy D" wrote:

Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is this
possible to do with an IF statement?

Thanks,

Tracy

Then just use CF with a condition of Cell Value Is and a formula, a formula
such as

=$M2<=1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Tracy D" wrote in message
...
Hi thanks for the help.

I actually would like to first look up a seperate cell and see if that is
less than one or not and then make a different cell red if it is. I was
hoping to use an IF statement but am not sure how to incorporate
fomatting.
Any help is greatly appreciated!

Tracy

"Tracy D" wrote:

Hi,
I am trying to set up a IF statement that if true would make the cells a
certain colour. Specifically, if the number is less than 1, make red. Is
this
possible to do with an IF statement?

Thanks,

Tracy