IF Statements

[Guest]

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

 

[Bob Phillips]

Conditional formatting.

Select the cells.
Format>Conditional 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)

 

[Bearacade]

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

 

[Guest]

You should have a look at conditional formatting

 

[Guest]

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

 

[Bob Phillips]

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)