| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rookie needs help with replace formatting and case change
I have some programming experience, but do not know VB.
I have spreadsheets for a league schedule that end up with several entries that are specifically "Bye". I need a macro to search for each occurrence of "Bye" and then replace it with "BYE" (upper case) but also with color red font. The sheets vary (not all the same size since some leagues run longer). Thanks for any help. See one of actual league schedule spreadsheets at my league web site: http://6amplayers.com/ click on matches on the left and then on "monday April 19, 2004" and then on the "Excel-file" link... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change data of entire column from small case to upper case | Excel Worksheet Functions | |||
| How do I change from upper case to proper case in excel 2002 | Excel Discussion (Misc queries) | |||
| Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
| How do I change a column in Excel from upper case to lower case? | Excel Worksheet Functions | |||
| How do I change existing text from lower case to upper case | Excel Discussion (Misc queries) | |||
![Jim[_45_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
