Coloring cells to left and right based on cell value

Hello all,

I am using the following code to change a range of cells color based on a specific value.

The following working code colors current cell + 4 cells to right:

Please Login or Register  to view this content.

The following fails when trying to color cells to left:

Please Login or Register  to view this content.

Not sure what i am doing wrong. Ultimately, i want to color cells in the current row from column A to column Q based on cell value of column M.

Full code:

Please Login or Register  to view this content.

Which is the condition for column M?

Why don't you use just Conditional Formatting?

I have not looked into it, has to be done in VBA though.

Just looking for something simple and easy to code, i am not sure how to start with conditional formatting.

Condition is, if Cell value <> 0

So nothing simplest from CF in this case!

Formula in CF rules.

Formula:

Please Login or Register  to view this content.

How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.