Conditional formatting problem

[Villalobos]

Hello,

I would like to ask some help regarding conditional formatting with formula. In range ("L9:L" & OutputLastRow) I would like to use the below mentioned Formula1 but I receive "Invalid procedure call or argument" error message.

Could somebody help me where is the problem?

Here is the code:

Please Login or Register  to view this content.

Thanks in advance the reply!

[duncandhu]

Hi Villalobos,

What does OutputLastRow evaluate to? When the macro stops because of the error, press "Debug" then hover the mouse over the variable 'OutputLastRow' and tell us what the value is.

You can also help by telling us which line the macro stops at.

Thanks,
Duncan

[Villalobos]

Hi Duncan,

Here is the sample. The original file has more thousand rows.
I would like to apply the conditional formatting formula until the end of last value in column L. The number of the values in column L are changing daily.

[duncandhu]

Hi,

Sorry for the delayed response - this actually worked for me without any errors.

Thanks,
Duncan

[Villalobos]

Hi Duncan,

Thank you the reply.
Unfortunately the problem is still open on my side. Maybe somebody know what could be the problem?

[CODE][/ .Range("L9:L" & OutputLastRow).FormatConditions.Add Type:=xlExpression, Formula1:="=AND(J9>0,K9<J9,O9>0,P9>TODAY())"CODE] this line cause the problem.

[duncandhu]

Like I said before, can you tell us what the exact error is? What is the value of OutputLastRow when the error occurs?