"" Then cell.Interior.Color = 3 cell.Font.ColorIndex = 2 cell.Font.Bold = True End If Next End Sub
Most valuable professional
  • Hot Topics

Excel adding a formula to VBA code

I have the following code which works plus a formula in cell range G5:G123....how do i add the the formula to the VBA code please Formula =IF(F5<>"".F5< today () +3 ) "" Then cell.Interior.Color = 3 cell.Font.ColorIndex = 2 cell.Font.Bold = True End If Next End Sub

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of July 11, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel