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"
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).