Personal Blog - GS Virdi

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