Help needed with IF function

[Adrian Jones]

Hi

Can anyone help me with this function:

I have a spreadsheet that keeps track of my truck inventory, as i add and
remove Items i log it in my Palm and it updates various cells, In Stock,
Used, Rec'd. I have a min value set in col E and if the value in col I is
<= then he work ORDER pops in Order column. This work fine but i want to be
able to see a different color for the OK or ORDER text:

=IF(I28<=E28,"ORDER","OK")

What I need to have happen is when the result that is generated is "ORDER"
then the text "ORDER" will be red, BOLD would be nice but red will do.

Can it also generate and email from the output in some form or another

Thanks

AJ

--
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
NOTE: This e-mail message is intended only for the named recipient(s)
above and may
contain information that is privileged, confidential and/or exempt
from disclosure
under applicable law.

If you have received this message in error, or are not the named
recipient(s), please
immediately notify the sender and delete this e-mail message

 

[Dave Peterson]

Take a look at format|conditional formatting on the worksheet menu.

You can tell it the colors you want based on the value in the cell.

Debra Dalgleish has some notes at:
http://www.contextures.com/xlCondFormat01.html