visick wrote:"For instance I will set the On Base count column to chge to red font for everyone over a 35 on base count, makes it reall easy to find viable leadoff hitters"
For us chiropractors that have no idea of what the hell we're doing in Excel...
How do you do this?
And FTR, I love the download, but the ratings book makes GREAT bathroom reading material.
Vis,
I'll see if I can step you through it.
First select the colum you want to highlight, I use OBP so I'll do that. Obviously you have to do it twice, once for each side.
Anyway, we'll do OB vs RHP, so select that colum by the letter at the top of the column, I believe it's column P.
Next, depending on what version of EXCEL you are running ( and I hope you are runnning office 2007) on the home tab there is a menu on the top of the sprwead sheet for conditional formating, click it. It brings up a drop down, click
New Rule on the drop down.
Next, On the next menu click under Select a rule type click the second line that reads:
Format Only Cells that containNow in the lower menu that reads Edit the Rule Description go to the second box, click the drop down arrow and select
Great than or equal to:Now click on the empty box and choose your value, we'll say 35.
Now click the format button, this calls up the Font format menu and allows you to change the font type, size, color, bold, underline, etc, basically anything you can do to the font. I usually selct Bold and change the color to red. Once you've made your changes Click okay on the bottom of the font editting box, which brings you back to the rule edit box.
Click ok on the bottom of that bo and your rule will now go into effect.
Please note, Text is valued greated than numbers for some weird reson, so the title of the column will change to. Once you've done it for the RH side you can easily copy and paste it to the LH side without setting up the whole thing step by step.
To copy from the RH side to the left, first select the colum with the rule you want to copy, then RIGHT click with your mouse and select COPY from the menu. Now select the column you want to copy the rule to then RIGHT click on that column. Select Paste SPECIAL and when the menu comes up, select Formats and then hit OK and you will paste the conditional formattin from one column to another.
If you screw it up you can hit the undo button and take things back to where you made the mistake.
Hope this helps.