fraggle 0 Posted June 20, 2011 A problem after or during a draft with offense cheatsheet (Excel 2003) Offense http://img840.imageshack.us/img840/7210/ccoff.png IDP http://img30.imageshack.us/img30/8835/ccidp.png Share this post Link to post Share on other sites
Mike MacGregor 20 Posted June 20, 2011 Hey fraggle. I'm not getting that over here for an IDP league. What have you done beyond running Compile Cheatsheets? It looks like the tiering is off (per the offense tab) but some tier lines show on the IDP tab. I did have a heck of a time with the conditional formatting (which is used to mark players as drafted), but thought it was all straightened out. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted June 20, 2011 Click on any of the player names on the IDP cheatsheet. Choose Format > Conditional Formatting. Can you take a screen shot of that? Share this post Link to post Share on other sites
fraggle 0 Posted June 20, 2011 http://img546.imageshack.us/img546/6872/formatidp.png German version of Excel off-notes is o.k. What have you done beyond running Compile Cheatsheets? Good question. I do it again tomorrow. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted June 20, 2011 Very interesting. Here is mine: Everything looks good. I don't know German, but I assume the English is translating correctly. Beyond that, lets check the cells in the hidden columns to the right of the IDP cheatsheet, columns AC to AH. Click on one of the cells highlighted light blue (cell AC9 for example). What is the formula you see there? Based on your first picture, it seems like for some reason the conditional formatting is triggering as being True, when really it shouldn't be because you haven't drafted any players yet. Share this post Link to post Share on other sites
fraggle 0 Posted June 21, 2011 What have you done beyond running Compile Cheatsheets? I disabled the automatic calculation. Now it works. Thank you for your help. Share this post Link to post Share on other sites