Two Formula Questions

  • Thread starter Thread starter BobA
  • Start date Start date
B

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?
 
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)
Click to expand...

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?
Click to expand...

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.
 
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.
Click to expand...

Thanks, Claus
 
Back
Top