Sif has attended:
Excel Advanced course
If ElseIF Statements + And
Hi there
I am trying to do If... ElseIf statement but cannot work out how to do these including and 'And' (I want to change the value of the cell AND the colour).
This is the code I have:
If (rngTrim <> ".") Then
If rngTrim > highPTile Then
rngTrim.Value = newHigh And rngTrim.Interior.ColorIndex = 37
ElseIf rngTrim < lowPTile Then
rngTrim.Value = newLow
End If
It is currently giving me 0s instead of returning the 'new' value (newHigh)
Thank you in advance!
RE: If ElseIF Statements + And
Hello Sif,
Thank you for your question. The AND and the OR functions are really meant to use in your IF or ELSEIF lines, to run more than one test on a cell. If you want to apply more than one action on a condition, rather write these expressions on separate lines.
I would suggest:
If rngTrim > highPTile Then
rngTrim.Value = newHigh
rngTrim.Interior.ColorIndex = 37
ElseIf rngTrim < lowPTile Then
rngTrim.Value = newLow
End If
I hope this works.
Kind regards
Marius Barnard
Best STL
