EXCEL

When I generate a bar graph in excel how do I make the highest bar a different color automatically? The chart generates itself as data is input into the spreadsheet. Is there a way to get the bar with the max data to turn red, let's say, when the rest of the bars are blue?

Also...I have 13 sheets in a workbook. Each sheet has many formulas that I don't want the users to mess up...so I lock them and allow input only in those cells that require data. I lock and protect each sheet individually. Is there a way to lock and protect all sheet in a workbook at the same time without having to do each sheet individually? I have over 25 people who use these spreadsheets and 25 x 13 is a lot of times to lock and protect. Thank you all for your inputs into these 2 problems. Pots and Pans