<div>
Fixed the procedure call error, thank you
</div>


Fixed the procedure call error, thank you

<div>
<div class="content wysiwyg-content">
Thank you for looking at my question,<br />
<br />
I want to format a range of cells on a worksheet using VBA (Excel 2013):<br />
<br />
&nbsp; &nbsp; .Range(&quot;A3:U&quot; &amp;&nbsp;lngBOMRows).Select<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; With Columns(&quot;A:U&quot;).FormatCondi<wbr />tions.Add(<wbr />Type:=xlEx<wbr />pression, Formula1:=&quot;=IF(Q1&gt;U1)&quot;)<br />
&nbsp; &nbsp; &nbsp;.SetFirstPriority<br />
&nbsp; &nbsp; &nbsp;.Interior.PatternColorInde<wbr />x = xlAutomatic<br />
&nbsp; &nbsp; &nbsp;.Interior.Color = 15773696<br />
&nbsp; &nbsp; &nbsp;.StopIfTrue = True<br />
&nbsp; &nbsp; End With<br />
<br />
<br />
For the range A3: last cell in U, if the value in Q is greater than U <br />
<br />
<br />
but I get a runtime error and invalid procedure call message.<br />
<br />
This also happened when I tried to set the font of a range of cells.<br />
<br />
I looked in the References, there aren't any there flagged as missing, presumably there is one that hasn't been ticked but I don't know which it is can you help?
</div>
</div>


Thank you for looking at my question,

I want to format a range of cells on a worksheet using VBA (Excel 2013):

    .Range("A3:U" & lngBOMRows).Select
    
    With Columns("A:U").FormatConditions.Add(Type:=xlExpression, Formula1:="=IF(Q1>U1)")
     .SetFirstPriority
     .Interior.PatternColorIndex = xlAutomatic
     .Interior.Color = 15773696
     .StopIfTrue = True
    End With


For the range A3: last cell in U, if the value in Q is greater than U 


but I get a runtime error and invalid procedure call message.

This also happened when I tried to set the font of a range of cells.

I looked in the References, there aren't any there flagged as missing, presumably there is one that hasn't been ticked but I don't know which it is can you help?

VBA Conditional Formatting Runtime Error '5' Invalid Procedure Call

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.