Bala-Krishna

Sometimes we need automatic colorisation of the rows based on the value of a cell. Its not only save lot of time as well as simplify identification of records based on the colors. Thanks to excel conditional formating that allow you to do. Formatting cell based on the condition is easy but formating entire row or column is little tricky.

To Do ->

Select the area you want to cover for formatting. You can select entire workbook if you want to cover complete all cell and columns.

Go to Format Menu -> Conditional Formatting

See the above figure, you will notice INDIRECT function. The INDIRECT function used to create cell or range reference while formula evaluated. The function allows you to put the address of another cell within a cell, and get data from the the other cell by referencing the first cell.  

The condition check column C in each selected row and change formatting according to specification.

Difference between DataGrid and DataGridView control

How to fix “Task Manager has been disabled by your administrator” Error

AC NIELSEN Migrated from Linux Server to Windows Server 2003

Internet Explorer(IE) 8 Beta Released

Bill Gates Leaving Microsoft - Retirement Session June 2008

September 20th, 2008 Bala Krishna Posted in MS Excel, Tips and Tricks, VBScript, Visual Basic, Web Development, Window Application, windows xp |

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.