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 ) Private Sub Workbook_Open() For Each cell In Range("F5:F19") If cell.Value < Date + 3 And cell.Value <> "" 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