IF Statements

T

Tracy D

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
 
B

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)
 
B

Bearacade

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

Tracy D

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
 
B

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)
 
Top