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. |