Help for this page

Select Code to Download


  1. or download this
    use Win32::OLE::Const 'Microsoft Excel';
[...]
...
$WS->Cells($i,11)->FormatConditions(1)->Interior->{ColorIndex}=
   xlYellow;
[...]
  2. or download this
    $WS->Cells($i,11)->FormatConditions->
   Add({Type} => xlExpression,{Formula1} => "=AND(J$i>0,K$i=0)");
  3. or download this
    $WS->Cells($i,11)->FormatConditions->Add(xlExpression,
   undef,"=AND(J$i>0,K$i=0)");