Select Code to Download

use Win32::OLE::Const 'Microsoft Excel';
[...]
...
     TextOperator => xlEndsWith });
$Range->FormatConditions(1)->Interior->{ColorIndex} = 3;
$Range->FormatConditions(1)->Font->{ColorIndex} = 5;