Change row coluor based on cell value

[JonSnow]

Aloha lads.

I'm almost entirely new to VBA and I'm just looking to make my basic code work at this stage.

As the title says, I want to change the colour of an entire row based on a cell value in column F. As below.

- 180 < F => color 15
- 120 < F < 180 => color 11
- F < 120 => color 6


A few notes - which might help.
- number of columns does NOT vary, it's A-H
- number of rows varies
- I normally use a Lastrow variable or the current region around A1 to account for that - please don't change that, I don't know other ones!

Code below is what I have now, it was put together from google searches but I can't understand sh*t from it, not even what's the bit that I need to customize. So if you want to scrap that and start over, that's fine by me.

Please Login or Register  to view this content.

[Norie]

Are you sure you need code?

The formatting you want could easily be done using conditional formatting.

[JonSnow]

Are you sure you need code?

The formatting you want could easily be done using conditional formatting.

Yep, I really need code for this one.

[JonSnow]

Hi guys, any help with this?

I was thinking, if the conditional formatting can be integrated in a Macro (if that makes sense), that would still work for me.