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