in reply to Re^2: excel conditional formatting
in thread excel conditional formatting
Problem solved. Thanks for everyone who chimed in.$WS->Cells($i,11)->FormatConditions->Add (xlExpression,undef,"=AND(\$J\$$i>0,\$K\$$i=0)"); $WS->Cells($i,11)->FormatConditions(1)->Interior-> {ColorIndex} = 6; #xlYellow
|
|---|