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
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of July 11, 2014.