Excel - Cell background

rohan_532

Hi need to loop over complete excel sheet rows and columns
the below code loops over the cells in column 'F' only can i loop over complete available columns in Excel sheet.

// Loop over the cells in column F
$('row c[r^="F"]', sheet).each( function () {
// Get the value and strip the non numeric characters
if ( $('is t', this).text().replace(/[^\d]/g, '') * 1 >= 500000 ) {
$(this).attr( 's', '20' );
}
});

Thanks .

F12Magic

Hi @rohan_532,

you clarified the question on my wall, and since this could be usefull to others, I'll answer this in the forum too.

Problem:
Check all cells in the sheet for a particular word, and color the background.

Answer:
See this JSFiddle: Working Example

Another example searching 2 words:
JSFiddle Example

rohan_532

Hello F12Magic ,

Thank you Very Much for your Help , This saved me :-)

Thanks.