in reply to Question on Excel OLE automation.

Have you checked the docs?
Specifically, How to: Refer to Rows and Columns.
Drop the quotes from your last version.
$Sheet->Rows(1)->Interior->{ColorIndex} =27;