cells with two formats

[Mark]

Hi

Is it possible to create cells with two or more  formats?  For instance, I have a table of multiple samples where each sample has multiple rows.  I would like to alternately color rows of different samples. Additionally, each row contains cells with hyperlinks.  When I attempt to shade rows with hyperlinks, only those cells without hyperlinks are shaded.  

Thanks much

[Mark]

Figured it out

my$bg_grey=$workbook->add_format();
$bg_grey->set_align( 'center' );
$bg_grey->set_bg_color('#E4E8E2');
$bg_grey->set_border('1');

my$bg_grey_url=$workbook->add_format(color=>'blue',
underline => 1,
);
$bg_grey_url->set_align( 'center' );
$bg_grey_url->set_bg_color('#E4E8E2');
$bg_grey_url->set_border('1');