Formula

[miller]

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?

 

[Gary''s Student]

Pull down:

Format > Conditional Formatting... > Formula is > =C2<=(E2*1.25)
and then pick the color

 

[miller]

Im using Office 07

Pull down:

Format > Conditional Formatting... > Formula is > =C2<=(E2*1.25)
and then pick the color

 

[Gary''s Student]

Luck you!

Conditional formatting is found in:

Home > Styles > Conditional Formatting

 

[David Biddulph]

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/excel/HA101491511033.aspx