I'm still having difficulty with Conditionl Format....

I like to apply the following...
In Column G
If cell equals number between 1 to 29 Colour Yellow on same row from
Column E to Column I
If cell equals number between 30 to 49 Colour Green on same row from
Column E to Column I
If cell equals number between 50 to 69 Colour Blue on same row from
Column E to Column I
If cell equals number between 70 to 89 Colour Mauve on same row from
Column E to Column I
If cell equals number between 90 to 99 Colour on same row from Column E
to Column I
If cell equals(or contains) "STR" Colour Orange on same row from Column
E to Column I
If cell equals(or contains) "Spare" Colour Grey on same row from
Column E to Column I
If cell contains "Shunting" Colour Dark Green on same row from Column E
to Column I
If cell contains "Patrols" Colour Pink on same row from Column E to
Coloumn I
If cell contains "" Colour Red ONLY That Cell

In Column M
If cell equals number between 1 to 29 Colour Yellow on same row from
Column K to Column O
If cell equals number between 30 to 49 Colour Green on same row from
Column K to Column O
If cell equals number between 50 to 69 Colour Blue on same row from
Column K to Column O
If cell equals number between 70 to 89 Colour Mauve on same row from
Column K to Column O
If cell equals number between 90 to 99 Colour on same row from Column K
to Column O
If cell equals(or contains) "STR" Colour Orange on same row from Column
K to Column O
If cell equals(or contains) "Spare" Colour Grey on same row from Column
K to Column O
If cell contains "Shunting" Colour Dark Green on same row from Column K
to Column O
If cell contains "Patrols" Colour Pink on same row from Column K to
Column O
If cell contains "" Colour Red ONLY That Cell

As it would need to be created in a Macro and I have no Idea on where
to start with Macro can u provide a step by step guide PLEASE

An Idiots guide on Macro would be great!! As I may need to make
additions later.

Many Many Thanks

Gunjani