Make cell change color and add text via BUTTON + MACRO

[Wise_87]

Hello!

I'm intrested if there is a solution to my problem which I've tried to google for the past 24h.
I'm working through a specific list which is working from column A-G and spreads from row 6<.
Whenever I enter data in column F I want a button that fills the selected/active row with a certain cellcolor from Ax - Gx and also adds a certain text message in G column.

I'm not new to VBA but my experience isn't that great. Is there any way of making this work?

Best of regards, Robin

[buran]

Something like this

Please Login or Register  to view this content.

It will work without button, but when you change cell in column F starting from row 6

[Wise_87]

It has to be working through a button since not every row with data will be colored.

[buran]

Please Login or Register  to view this content.

[Wise_87]

Outstanding! Works perfect, thank you alot!