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?

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?

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?

Luck you!

Conditional formatting is found in:

Home Styles Conditional Formatting
--
Gary''s Student - gsnu200800


"miller" wrote:

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?

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?