VBA Query - Highlight Specific Cells

[uzzimacro]

Hi All,

Very new to VBA. Wondering if anyone can advise on a macro code to highlights cells based on their value?

Basically want to run a macro that will look in column J and highlight every cell that has a numeric value above 40,000.

Regards,

UMac

 

[SteveO59L]

have you considered conditional formatting?

 

[uzzimacro]

Yes I tried a few things but im very beginner so kept running into errors,

 

[Joe4]

Its pretty straightforward.
Just select the column, go to Conditional Formatting, select the "Highlight Cell Rules"" option, then choose the "Greater Than" option, enter your value and choose the highlighting option you want.

 

[uzzimacro]

thank you very much! apologies was unaware I could record the macro whilst performing the conditional formatting! Appreciated