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

 

[Bob Phillips]

See response to previous post.

--

HTH

RP
(remove nothere from the email address if mailing direct)


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