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?