Tuesday, January 24, 2012

Highlighting row based on particular value in Excell

Dear Colleagues,

Very Frequently I’ve come across this requirement when I’m asked to suggest Excel formatting solution where a user needs to highlight the complete row based on some particular value in another column/cell in the same Excel workbook.

The solution is very simple, this formula applied in “Conditional Formatting” will do the trick……  =INDIRECT("ColumnNo"&ROW())="Value"
Ex:
=INDIRECT("E"&ROW())="Pending"

1.       Go to Conditional Formatting (option),
2.       Select “Use formula” (option),
3.       Enter the above formula with appropriate ColumnNo & Value,

4.       Select the range to which this Formatting should be applied…
And u’re done.


Contact me in-case of further clarification(s).

G.S Virdi

Beauty of Thoughts, Magic of Words - GSVirdi

This is what happens when: When u have somebody whom u know loves u completely, and as u start thinking about them.... Everything in life ...