Macro Help: IF A1 bigger than B1, color

[Antiq]

Hello, I often use excel at work to compare classroom seat counts and think I could use a macro to make the job move quicker. I have the data pulled in like so:
seats.PNG
I would like to run a macro that will compare column H and J and color the cells in if H is a larger number than J. For instance, in this image, I would need row 7 (or even any single cell in row 7) to change color to signify that there are more requests than available seats. If anyone can help me build up some VBA, or point me in a good direction to start building this macro myself, I would really appreciate it. I only recently started using macros at all and all my coding background begins and stops with HTML

[mjr veverka]

Welcome to the forum,

Does it have to be a macro ?
Maybe just ordinary conditional formatting ?

[Antiq]

Thanks!
If something other than a macro would work for it, I'm game. It just has to be repeatable across multiple workbooks and different datasets, is the only thing. I know that this is the Macro Help forum, but would you be able to give me an idea of how to set up a specific conditional formatting for this purpose?

[BellyGas]

Please Login or Register  to view this content.

Frankly, writing this was quicker than conditional formatting.

[mjr veverka]

... If something other than a macro would work for it ...

Select the appropriate range in the 'H' column
Select the conditional formatting icon
Select New Rule
Select Use a formula to determine which cells to format
Enter a formula in the field =$H2>$J2
Select the appropriate formatting

A small guide:
https://support.office.com/en-ie/art...b-f1951ff89d7f

[Antiq]

...Frankly, writing this was quicker than conditional formatting.

Sorry for the beginner response but I can't get this code to work for me. I get a compile error

Select the appropriate range in the 'H' column..

Is there a way to get this to work for more than just the first selected cells? I've tried (for instance) "=$H>$J" and other variations and cannot quite get it to work for me.

I really appreciate both responses. Apologies for the newbie questions

[mjr veverka]

Is there a way to get this to work for more than just the first selected cells?

Yes of course, first select more than one cell and then as above (=$H2>$J2)

Edit:

or use the format painter

[Antiq]

...or use the format painter

Whoops, completely forgot about the format painter. That works. Thanks so much!