Changing cell color using VBA

Hi, I am trying to change the cell color using VBA programming and I keep receiving an error for my code. The error I get is "object doesn't support this method"

Please Login or Register  to view this content.

Remove the asterisk from the first Value property.

Sill mistake on my end thank you.

Do you know how I could make that a loop so it continues down the page reading all the cells? Like next it will it for R3 & Q3 then R4 & Q4, etc?

How far do you want it to go, and is there a reason to not just use conditional formatting for this?

It would have to go pretty far down, like a couple thousand rows. It can't be conditional formatting because I am using a command button so I can like click on the button then the code will run and the cells will highlight.