Chandanamazha 10-3-15 Visualize cell values with conditional formatting(Excel 2007, 2010)

              When making reports in Excel, you may wish to highlight certain cell values by using visual aids in the worksheet.
              Select the cells whose values you want to support visually and click “Conditional Formatting” in the “Home” tab. Here, you can select from several predefined formats. These include ‘Highlight Cell Rules’, ‘Top/Bottom Rules’, ‘Data Bars’, ‘ColorScales’ and ‘Icon Sets’. Under ‘Highlight Cell Rules’, you have the option to highlight data that is greater, lesser, equal to, or between the specified values. Apart from this, you can also highlight according to text, date and duplicate values. The ‘Top/Bottom Rules’ allow you to highlight the top ten, bottom ten, above average, bottom average and even top/bottom ten based on percentage.
               For representing the data in a more appealing way, you can even make use of the ‘Data Bars’, Color Scales’ and the ‘Icon Sets’. With the help of the ‘Data Bars’ you can make use of colored data bar within the cell. Here the length of the data bar corresponds with the cell value. So higher the value, longer will be the bar. You can also make use of the ‘Color Scales’ that displays two or three color gradients in the range of the cells, where the shade represents the value. Alternatively you can make use of the various icons from the ‘Icon Sets’ to represent cell data visually.

Read More...

Amma 10-3-15. Highlight the active cell in Microsoft Excel(Excel XP, 2003, 2007, 2010)

              It is often difficult in large tables to find the active selected cell. You want to configure Excel in a way that this cell always and automatically stands out from the rest of the sheet.

              When working on large tables, it becomes difficult to find the active cell. To solve this problem you can download a free add-in named RowLiner, which can be downloaded from http://www.cpearson.com/excel/rowliner.htm. Double click on the file to install it. Once installed, it can be accessed form the “Add-ins” tab from the menu bar. Once activated, it will highlight your active cell. To change its settings, click “RowLiner” in the “Add-ins” tab and select the “RowLiner Setup”. Here you have different options for rows and columns, as to where these are shown and how they should appear. To the right, you can control the structure of the active cell. Then confirm the configuration with “OK”. However, the “Undo” function is not available in active RowLiner. In case of extensive entries, you should deactivate RowLiner temporarily. For that, click “RowLiner” in the “Add-Ins” tab and deactivate the “Draw Lines” option.

Read More...