Excel help.....

[archiesdad]

Oh wise ones I need some help.

I want to create a macro 'button' on a spread sheet so when you 'press' it it will turn whichever cell you have highlighted (maybe I mean the cell the curser is on) on that spread sheet a different colour ? I've nee idea if that makes any sense but I hope it does to someone

ps - I am a technophobe..... please be gentle.

 

[Some Random Guy]

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
.Worksheet.Cells.FormatConditions.Delete
.FormatConditions.Add xlExpression, , "TRUE"
.FormatConditions(1).Interior.Color = vbYellow
End With
End Sub

 

[sedling]

Tom’s Tutorials for Excel: Color the active cell, row, or column

 

[Ambivalent Dave]

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
.Worksheet.Cells.FormatConditions.Delete
.Format.thefucker. xlExpression, , "Aye"
.Format.thefucker(1).Interior.Color = vbYellow
End With
End Sub

Tidied

 

[archiesdad]

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
.Worksheet.Cells.FormatConditions.Delete
.FormatConditions.Add xlExpression, , "TRUE"
.FormatConditions(1).Interior.Color = vbYellow
End With
End Sub

mate that looks great but wtf do I do with it ?

 

[Ambivalent Dave]

mate that looks great but wtf do I do with it ?

Enable the developer tab, in the ribbon settings or summat

Click on the VBA button, paste it in

 

[Some Random Guy]

Enable the developer tab, in the ribbon settings or summat

Click on the VBA button, paste it in

Pretty much this then slap in a button and assign the macro.

That code may not even work, just copy and pasted it from another site.

 

[archiesdad]

sorted cheers all

 

[Bishop Mackem]

Punching the monitor usually works for me

Hope this helps

 

[archiesdad]

Punching the monitor usually works for me

Hope this helps

Nope

 

[Deleted User 11453]

It’ll be quicker with these.

Logon or register to see this image

 

[Kevj]

Oh wise ones I need some help.

I want to create a macro 'button' on a spread sheet so when you 'press' it it will turn whichever cell you have highlighted (maybe I mean the cell the curser is on) on that spread sheet a different colour ? I've nee idea if that makes any sense but I hope it does to someone

ps - I am a technophobe..... please be gentle.

Maybe I am missing the obvious here. Excel has a button in the ribbon to change cell colour. Highlight the cell(s). Press the button.

Logon or register to see this image

^that one is for text, the cell colour version is exactly the same and is positioned next to it.

 

[Edinburgh Black Cat]

Oh wise ones I need some help.

I want to create a macro 'button' on a spread sheet so when you 'press' it it will turn whichever cell you have highlighted (maybe I mean the cell the curser is on) on that spread sheet a different colour ? I've nee idea if that makes any sense but I hope it does to someone

ps - I am a technophobe..... please be gentle.

Shirley the curser will be on the button when you click it?