Two Formula Questions

[BobA]

Two Questions:

1. If I type msft into a cell, can I automatically have it change to MSFT? (All Caps)


2. I have a column of numbers and some of them have a certain fill color. Can I create formulas that will add/subtract, etc., the cells that are a certain color?

 

[Claus Busch]

Hi Bob,

Am Thu, 4 Sep 2014 05:32:44 -0700 (PDT) schrieb BobA:

1. If I type msft into a cell, can I automatically have it change to MSFT? (All Caps)

if you want it automatically then goto Options => Proofing =>
AutoCorrect Options => AutoCorrect => Replace msft => With MFST

If you write it in A1 you can use the formula in B1:
=UPPER(A1)

2. I have a column of numbers and some of them have a certain fill color. Can I create formulas that will add/subtract, etc., the cells that are a certain color?

You need an UDF to do that.
For adding the values you could filter by color and use
=SUBTOTAL(9,A1:A100)


Regards
Claus B.

 

[BobA]

Hi Bob,



Am Thu, 4 Sep 2014 05:32:44 -0700 (PDT) schrieb BobA:






if you want it automatically then goto Options => Proofing =>

AutoCorrect Options => AutoCorrect => Replace msft => With MFST



If you write it in A1 you can use the formula in B1:

=UPPER(A1)






You need an UDF to do that.

For adding the values you could filter by color and use

=SUBTOTAL(9,A1:A100)





Regards

Claus B.

Thanks, Claus