Using a variable in conditional formating

[Djblois]

My last row is always different and I would like to do a conditional formating on the last column based on the total of that column. However, I can't figure out how to get the conditional formating to work

[VBA]Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, Formula1:=finalCell[/VBA]

That is my code and finalCell is my variable.

[Zack Barresse]

Hi there,

Kind of hard without seeing the rest of your code. Why use Selection? What is finalCell?

[Bob Phillips]

My last row is always different and I would like to do a conditional formating on the last column based on the total of that column. However, I can't figure out how to get the conditional formating to work

[vba]Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, Formula1:=finalCell[/vba]
That is my code and finalCell is my variable.

How about using a formula that calculates the last cell, maybe a dynamic range formula or something?

[Bob Phillips]

Looking at your previous post I see that FinalCell does just that.

As such, yoiur code seems to work. The only thing I could think was to delete them first

[vba]

Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, _
Operator:=xlLess, _
Formula1:=finalCell
[/vba]

What difficulty are you having with it?