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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.