VBA - Conditionally Change Cell Colour

I am struggling to get some VBA code to run properly (or even run at all, frankly) - it keeps flagging errors, and no matter what I try to adjust it, it will not execute. I have successfully tinkered with code in the past, but this is the first time I've attempted to write something more-or-less from scratch with only basic sections pulled off the internet (as I could not find anything designed to do this sort of thing), so I may be missing something quite fundamental.

The intent is to change the colour of cells in a table based on whether the value of the first column exceeds the number in the row header. I have provided a snapshot of my spreadsheet for reference:

\1

If the value in column C is less than or equal to the value in row 1, the corresponding cell colours in D2:H16 should match the colour in column J. If the value is greater, the cell should be light grey. I have a chart with formatting tied to the cell colours, so I need to change the colour of the cell itself, not apply a conditional formatting rule.

Here is my attempt at coding:

Please Login or Register  to view this content.

Any help would be very much appreciated!

Please use code tags when posting code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Hi, welcome to the forum

You dio know you can do this with regular CF, right?

It would be helpful if you would actually post a spreadsheet, we can then use your data example and the colors you want. Please also put a sample of the grey color you want.

If the value in column C is less than or equal to the value in row 1

Which value, you have 5 numbers in row 1?

What is the significance of the 1's and in one case 2's in the colored rows?

Why do the color bands only go part way across some of the rows?

Okay fine. How about the sample sheet?