Macro Creation - Sort Rows, Add blank row, conditional format text

[lichldo]

I'm looking for assistance in setting up a macro to do the following.

1. Add a blank row in between each set of value from Column G.

• Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this -
  • Bob
  • Susie
  • Susie
  • Lauren
  • Bob
  • Lauren
  • Susie
  • Chad
  • Lauren
  • Bob
  • Bob
  • Chad
• I want the macro to sort the rows so that all Handlers are grouped together, but also add a blank row in between each section

2. Once the handlers are grouped together, Columns I through O have number values that need to be totaled per handler group. That is what the blank row is for - to have the space to total each section.

3. Bold the first row and freeze it

4. Color any number value under $50,000 as green text, and color any number value over $75,000 as red text


Thank you for any help and guidance

 

[lichldo]

solved this!

 

[Peter_SSs]

Glad to hear you got the solution.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.