[simplepa]

i have a spreadsheet and basically what I want to do is if a certain cells equals to a name, then I want that that row to change to a color thatI assigned to that name, which is blue. I already have done done but what I need help with is that if the other on that row doesnt have a value, then I want it to stay white color but if I add a value to a cell within that row, then I want it to turn blue. Please keep in mind that I have 7 names that I've assigned a color to that name.

[Zack Barresse]

Hi there,

Can you provide some specific examples? Or better yet post a sample file?

[simplepa]

here is the sample

[Zack Barresse]

So for your blank cells, if you want them blue with any value, select those cells, goto your CF (Conditional Formatting) on the Home tab, New Rule, Cells That Contain, change Between to Equal To, in the box on the right put in the asterisk (*) character, change the format to what you want.

Is that what you're looking for?

[simplepa]

yes something like that. however, I would have several names in the "name" column, and each name will correspondond to whatever color is assigned to their name. So in my example, Don has blue and John has green and Trishia has orang. So in the row where their name is listed I want the cell to change to their assigned color when a value entered

[Zack Barresse]

You could do this with VBA, but I don't know of a way with standard CF. Are you opposed to VBA?

[simplepa]

No I am not opposed to using VBA. But quite honestly, I dont know anything about VBA. If you can help me with that, that would be great.

[Zack Barresse]

Sure, np. Can you define the entire range where you would want this to apply to? Also, is your workbook going to contain that list somewhere, which has the name associated with it's respective color?

[simplepa]

well the ranges vary. it would have about columns and the row expanda as I add more info. As far as the names, it is not listed anywhere. It is manual input but i have about 7 names. Is there a ways where you can write the vba code for me and maybe a can just copy it and maybe deit it with the correcy names and or add the ranges?

[Zack Barresse]

Well somebody might, but I won't. Don't take this the wrong way, but it would be the same as if you told me and I wrote it, but I would have more information. I could write some general code to do what you're asking, but I would need more details still. It's too non-specific. I can point you in the right direction if you want.

You'd need a worksheet change event
I'd start with testing the range, ensuring it's in the right location
Test the number of cells selected, decide if you want code to run on all cells or not
Test the value of the cell being changed, if it matters or not
Call code, or have in same routine, to check some range for some name for some color and make it the same

I know it's not direct, but neither are the details, but those are the lines of thought I had.

[simplepa]

Thanks. But you just lost me. Would it be better if I send you the worksheet?

[Zack Barresse]

Don't email me, just attach the file to your post here.

[simplepa]

here it is, The names are not there yet sunce it is manually entered.