Tuesday, January 24, 2012
Highlighting row based on particular value in Excell
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).
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 ...
Gaudi mahalla panjwan Gauree, Fifth Mehl: Gur ka darshan deikh deikh, jeewan. Gur ke charan, dhoie dhoie peewan. Beholding the Blesse...
Hello Friends, After many years I decided to use my fountain pen again, so I bought two ink bottles from Bril (Royal blue & Violet) a...
Dear Readers, I am posting to know about the whereabouts of this mysterious reader on my blog. I do thank u all for all ur visits, but th...