extrasupereasy macro question

[invisigirl]

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.

 

[Von Pookie]

Al,

I don't think anything was wrong with your code.

I just thought that she may want the information in separate columns for convenience, instead of adding the .1/2 to the same column which could get quite confusing.

 

[Al Chara]

invisigirl,

Post exactly what you want to happen.