invisigirl
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 130
I am completely virginal when it comes to the macro. I think this will be a pretty easy question for someone to answer, and I apologize if it's redundant to the board in any way, but I didn't have time to go through all 130 pages of what's already been asked.
Anyway, I have a spreadsheet where I have to enter unique account numbers for clinics. Some clinics are one affiliation, some are another affiliation, and some are no affiliation. I put the text in bold red for the first affiliation and bold blue for the second. Nothing special for no affiliation.
What I thought I'd do is type a .1 at the end of the number when the clinic has type one affiliation & a .2 for type two affiliation, then put in a macro to pick these up and change the text color.
Is this pretty easy to do? Can anyone give me the code for it?
Thanks for your assistance, and might I add that you look really hot today.
Anyway, I have a spreadsheet where I have to enter unique account numbers for clinics. Some clinics are one affiliation, some are another affiliation, and some are no affiliation. I put the text in bold red for the first affiliation and bold blue for the second. Nothing special for no affiliation.
What I thought I'd do is type a .1 at the end of the number when the clinic has type one affiliation & a .2 for type two affiliation, then put in a macro to pick these up and change the text color.
Is this pretty easy to do? Can anyone give me the code for it?
Thanks for your assistance, and might I add that you look really hot today.