cell colour

[capsican]

I have a spreadsheet that has peoples names against a row each person has a different colour. what i would like to do is have it setup so that when a row of cells is pick next to the name it auto puts the persons colour in the cells.

I can send the spreadsheet to you if it makes it easier.

thanks heaps
Cathy

 

[Smitty]

Welcome to the Board!

What version of Excel are you using? If it's 2007 you have pretty much unlimited options with Conditional Formatting. Otherwise you'll be stuck with 3 options, but you can use VBA as a workaround (but you need to give more details for that).

Take a look at the link beneath my sig for how to post a shot of your sheet.

HTH,

 

[Chris Bode]

Let us suppose that names are in column A

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
Private Sub Worksheet_Change(ByVal Target As Range)<o:p></o:p>
    Sheet1.Cells(Target.row, Target.Column).Interior.Color = Sheet1.Cells(Target.row, 1).Interior.Color<o:p></o:p>
End Sub