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.

[invisigirl]

I should probably add that these numbers are all entered in the same column.

[Von Pookie]

Good news! You don't need a macro!

If you're going to put the .1 or .2 at the end of them, all you need to do is go to Format/Conditional Formatting and you can set it to change text/background colors if it meets your specifications.

[invisigirl]

Well...I had tried that before. I can't see where I am able to specify that the number *includes* any certain digits. Am I just having a blonde moment?

If all that was in that cell was .1 or .2, then I would know how to do it with conditional formatting, but this is a 5-digit number *ending* with .1 or .2. I probably wasn't clear on that before. Sorry!

[Von Pookie]

Ah...I inadvertantly missed the "one column" thing.

If you had the 1 or 2 in the cell next to it, for example, it would work.

Sorry!

[invisigirl]

I considered that as well. I could split out the number after the decimal to a new column and be able to make the ones and twos in THAT column red or blue, but I still didn't know how I'd make the 5-digit account number follow the same formatting.

I'm sure this is a simple thing to do with a macro or some other type of visual basic script, but I know zilch about either.

Thanks for trying to help, though!

[Al Chara]

Try the following procedure:

Add conditional formats to the first cell in the column (I assumed the first cell was A1). Then to test if the cell is account 1, select Cell Value is equal to and put in the following formula:
=A1-MID(A1,6,2)+0.1
Add the format bold and red text. Then to test if the cell is account 2, select Cell Value is equal to and put in the following formula:
=A1-MID(A1,6,2)+0.2
Add the format bold and blue text.
Then copy and paste the "format" down to the rest of your cells.

This procedure assumes that the account number is 5 digits and then a .1, .2, or nothing.

[Von Pookie]

Or, if you want to put the 1/2 in the other column, you could select the column with the 1/2 and set the conditional formatting to whatever colors you want.

Then, select the other columns, and go to conditional formatting and select "Formula is" then enter =$b1=.1 (assuming the clinic number is in A1).

Then, just click add and change the formula to =$b1=.2 and set your colors.

Hope we've helped you!

[invisigirl]

Yay! That worked. Thank you very much.

[ This Message was edited by: invisigirl on 2002-03-20 13:15 ]

[Al Chara]

What didn't work with my code?