Thread: IF Statements
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tracy D Tracy D is offline
external usenet poster
 
Posts: 1
Default IF Statements

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