Conditional Formatting, in Excel
I've uploaded, to my site, a tutorial for utilizing Excel's "Conditional Formatting" feature to "highlight" certain cells which meet specific criteria. This ability helps the user visualize values or conditions that are important to them. In this tutorial I show how to "conditionally format" the top 3 ranking horses in the "Fractionals", in the "Pace Ratings" view of the spreadsheet. So, after applying the formatting, the top 3 ranked values for "FR1", "FR2", and "FR3" (feet per second velocities) will be highlighted by bolding the font and adding shading colors to those cells. If you've seen AllData PPs, you'll have noticed this highlighting for other cell ranges.
It's not hard to do and after doing it a couple of times you'll become quite proficient in it's use.
So, go to my site, click the "Modifying AllData PPs" tab, scroll down to the section titled "Adding Conditional Formatting to AllData", follow the instructions for downloading the ".zip" file, and opening the tutorial.
Hope you "get it" easily, it's really a "neat" feature in Excel.
Have fun experimenting!!
Last edited by raybo; 07-10-2010 at 03:53 PM.
|