Hi,

Could I get a hand interpreting this code?? I gather that IF is an
alias for IIf with the syntax: IIf(expr, truepart, falsepart)

ActiveCell.FormulaR1C1 =
"=IF(RC[-1]=0.04,IF(RC[-1]=0.05,""Substantial"",""Alert""),IF(RC[1]=""
"",""No"",""Alert""))"

I want to modify this so when the expression evaluates to
"Substantial" the whole row is highlighted too. Any ideas?

Cheers!