Formatting based on count statement

[harrisj_]

VBA Code to count how many cells in column G contain a number greater than 0.

Then put All Borders around F4:J4 on a different sheet, going down the amount of rows from the first number.

So for example, if column G contains 6 numbers that are greater than 0, then format all borders around F4:J9

Thanks

[satabp]

Try this

Please Login or Register  to view this content.