Forum Discussion

FatManFluff's avatar
FatManFluff
Brass Contributor
Sep 05, 2024
Solved

Conditional Formatting Help

Good morning was looking for a way to format my excel sheet based on slips being staple. Currently I reference the group by marking an X after the group number. Down below I will post an example of what I mean. 

 

Currently the best I've been able to do is to just highlight the slip # when it finds and X by the group number, but I would like to box the group as well.

 

 

Any help would be highly appreciated it

 

 

7 Replies

    • FatManFluff's avatar
      FatManFluff
      Brass Contributor

      Patrick2788 thank you for the quick response. What I want to do is box the slips between each X. The X is my indicator to let me know those slips are stapled together. The highlight is just telling me that the start of the stack stapled but I don't always have the same number of slips grouped. This is what I would like it to look like.

       

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor

        FatManFluff 

         

        In your initial description you say "...but I would like to box the group as well". On the other hand your in last reply the Group are not boxed. Quite confusing so not sure the following is what you want:

Resources