Row background

horus1613

How can I paint over the entire row?

    $('row c[r^="E"]', sheet).each( function () {
                        // Get the value
                        if ( $('is t', this).text() == 'London' ) {
//                            $(this).attr( 's', '20' );
                              $(this).closest( 'tr ').attr( 's', '10' );
                        }
    });

This doesn't work!

horus1613

$(this).closest( 'tr' ).find('td').attr( 's', '10' );

This doesn't work too...

colin

Hi @horus1613 ,

Take a look at this example here, this is doing what you're after. If you want to change the colour/style, they're listed on this page here.

Cheers,

Colin

horus1613

Colin, thanks!