Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Color changes are happening in SHEET1 but not SHEET2. How do I change the "active sheet" to SHEET2? www.apexhandtherapy.com/hal4.xls HAL
  2. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Color changes are happening in SHEET1 but not SHEET2. HAL
  3. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    I am hoping that the following file has what you suggested. I moved the auto text part to "SHEET2". www.apexhandtherapy.com/hal3.xls Thank you, HAL
  4. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Thank you. I am working on it. Hal
  5. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Hello SkipVought, - I realized that storing each persons data in one row was better, but, I felt lazy and moreover, pressing "ENTER" highlights below cell. - I thought of keeping data entry to "SHEET1" and auto data entry to "SHEET 2" and making only selected area on "SHEET 2" to print. But...
  6. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Hello SkipVought, - Following is a link to the file www.apexhandtherapy.com/hal.xls - Entering Data in cells C6:M10 will automatically populate data in cells A12:K70. - I want the cells A12:B70 & I12:J70 to automatically change color based on the Alphabet. Thank you, HAL
  7. hal10000

    Excel - Changing Cell Color Automatically for Auto Text

    Hello, - I have "First Name" in all A1. - Cells B15 & C15 use the formula "=UPPER(LEFT(A1,1))" to get the first letter in A1. - I want the color of the cells B15 & C15 to change automatically depending on the "Upper Case Letter". - I used the following code (modified from the code I got...

Part and Inventory Search

Back
Top