Fill certain cells in next empty row certain colour

[Ironman]

Hi

I'd very much appreciate a macro to fill columns A:F and I:J of the first empty row of sheet 'Training Log' with colour (RGB) 197 217 241 (in the Format Cells > Fill display, it's the 4th cell in the second row - pale blue).

Similarly, I need a second macro to fill columns A:J of the first empty row of sheet 'Training Log' with colour (RGB) 217 217 217 (in the Format Cells > Fill display, it's the 1st cell in the third row - light grey).

Many thanks!

 

[Ironman]

P.S. I'd like to be able to activate this with the keyboard shortcut

Application.OnKey "^\"

 

[Ironman]

Mods please delete - my second post appears as answered, so re-posted and resolved here