Additional Info

Share

"" Then cell.Interior.Color = 3 cell.Font.ColorIndex = 2 cell.Font.Bold = True End If Next End Sub
  • 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 ()+3)>

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