Conditional Formatting usng Two Columns Header

Hi,
I have 1 sheet with a range, for example, from A1 to D4. I wish to create a VBA code for conditional formatting:
Highlight any value in Garage (column D) if:
- the Location (column A) is D
- and the Garage (column D) is NOT between 6 and 10

I created the following code, but unsuccessful. Can anyone help me to find what is not correct?

In column D, I use header name as a reference. How do I do the same for column A?

Thank you very much. I also attached the sheet as an example.

Please Login or Register  to view this content.

Hi Sintek,
My apology for the late response.
Much appreciated your assistance. It works!

Sintek,
Suppose I want to use R1C1 style by referring to the header names.
I was trying to write a code below, but unsuccessful.
Can you point me to errors I made? Or it all mess up?

Thank you.

Please Login or Register  to view this content.

Sintek,
Correct me if I am wrong, I changed the column number to 4 as you noted. Bit it didn't give any highlight. Any thought?

Please Login or Register  to view this content.

Many thanks, sintek. It works!
Much appreciated your help.