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]

Use condition al formatting and test for that value.

--

HTH

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

 

[RagDyeR]

Say the "Order" column is column K, then select K2 to K100, and then:
<Format> <Conditional Format>,
And expand the left box and click "Formula Is",
And enter this formula:

=$K2="order"

Then choose your format, where you can select *both* red and bold.
Then <OK> <OK>, and all the selected rows will now display RED when "order"
is returned from your formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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

 

[Adrian Jones]

RD

Thanks for the help, the example was right on and it does what i wanted

AJ

 

[Ragdyer]

Thanks for the feed-back.