Highlighting cells

[Jay Kelly]

Is it possible to write an if statement that would highlight a cell in
yellow if the value in that cell was greater then $1.00 and if so how would
I write that.

Thanks in advance for any help.
__________________________________________________________________ Jay Kelly
ICQ#: 59630211 Current ICQ status: + More ways to contact me
__________________________________________________________________

 

[J.E. McGimpsey]

Not an if statement, but look at Conditional Formatting in XL Help.

For more, you might take a look at David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/condfmt.htm

or Chip Pearson's site:

http://cpearson.com/excel/cformatting.htm

 

[Malcolm]

Check out Conditional Formatting in Help. It does
exactly what you want.