There are a couple of ways you can choose to do so, however.Ĭonditional Format that Checks for Data TypeĬonditional formatting can be used to highlight cells that contain the improper type of data for your needs. If you have a data table in a worksheet, and you want to shade various rows based on whatever is in the first column, then you can use Excel's conditional formatting capabilities. You can write your own macro to do the formatting change, however.Ĭhanging Shading when a Column Value Changes Tired of the default colors that Excel uses to display the row and column coordinates? You can modify the colors, but only if you make the change in Windows itself.Ĭhanging Font Face and Size ConditionallyĬonditional formatting does not allow you to change the typeface and font size used in a cell. If you want your users to answer your questions in a specific order, you can use both data validation and conditional formatting, as described in this tip. It is not unusual to use Excel to gather the answers to users' questions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |