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