Formula
 

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?

Formula
 

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?

Formula
 

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?

Formula
 

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?

Formula
 

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?