If you haven't yet learned where to find the Excel 2007 equivalents of Excel
2003 functions, it sounds as if you need
http://office.microsoft.com/en-us/ex...491511033.aspx
--
David Biddulph

"miller" wrote in message
...
Im using Office 07

"Gary''s Student" wrote:

Pull down:

Format Conditional Formatting... Formula is =C2<=(E2*1.25)
and then pick the color
--
Gary''s Student - gsnu200800


"miller" wrote:

Here is my formula

=IF(C2<=(E2*1.25),"order","")

Instead of "order" i want the cell to turn a color...doesent matter
what
color any ideas on how to do this?