ActiveCell.Formula and IF statement

D

David

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!
 
B

Bernie Deitrick

David,

Essentially:

If ActiveCell(1, 0).Value > 0.05 Then
ActiveCell.EntireRow.Interior.ColorIndex = 3
End If

The "IF" is not an 'Alias' for IIf: your code snippet puts an IF formula
(actually, a nested IF) into the activecell. And the formula doesn't look to
be well constructed, but that wasn't your question....

HTH,
Bernie
MS Excel MVP
 
Top