I know, I know. It’s mid-March, college basketball is taking over your time, and you’re in the final push of draft preparation for your baseball leagues. The last thing you want to do right now is start tinkering with your draft spreadsheet and screw something up.
Then here I come with another monster Excel post…
NOT THIS TIME! I swear. This is an easy one and you might find it helpful.
In this post I’ll show you how to use Excel’s conditional formatting to gray out players that have been chosen during your draft.
Excel’s Conditional Formatting
Conditional Formatting is a way to adjust the format of individual (or many) cells based upon the information within that cell. If you were using this in a business spreadsheet you might want really high sales months to show up in bolded font or below average sales people to show up shaded in red.
For fantasy baseball you might want all players projected to hit 30 HR to have their HR projection in bold red font. Who knows.
The point is you can tell Excel “what to format” and “how to format it”.
I’m using Excel 2013 in the screenshots below. I think this will work on Excel 2007 or 2010 without any issues. I’m also assuming you’re starting with a spreadsheet you created following either this standings gain points series or this points league series.