![]() Each screenshot I pasted into the spreadsheet. This screenshot method required me to take successive screenshots of the rules (since a screenshot can only get 4-5 at a time, I needed 5 screenshots.). The result of my searches came down to "Take a screenshot of the rules manager." Which works, but the result is not as useful as you might think. As I usually do, I searched both EE and the rest of the internet for the best ways to make this legend. ![]() ![]() I decided that one way to make this clearer was to incorporate a legend. It was then that I realized I had to include some better instructions. This guy is a former VP of Pepsico, so no slouch. A colleague asked me to go over how it worked with him because he was a little confused. I had created about 25 different rules that determined what font and background each row was assigned (those were the conditional formatting rules). ![]() The spreadsheet I created just tracked membership for a relatively small group (less than a thousand). I was wrong about this, although it took an oblique comment in order for me to find that out. I thought the spreadsheet I created was not only fairly cool, but since it had a bunch of different conditional formatting (read more about conditional formatting in my article here ) that highlighted different rows depending on the values entered, explained itself fairly well.
0 Comments
Leave a Reply. |