Hello-
I'm wondering if I can get a little help on the following code. Basically, I would like to use the conditional formatting function to highlight values in a particular column that are greater than a value in the same column, but not part of the selected range.
I can do it easily for one column but when I try to modify the vb code to select the new value for comparison (trying to use the active cell column) in order to use the same conditional formatting to subsequent columns the code won't work.
I'm pretty clueless when it comes to VB, so I'm guessing it's something simple. Any help is appreciated.
Thanks,
-Tom
I'm wondering if I can get a little help on the following code. Basically, I would like to use the conditional formatting function to highlight values in a particular column that are greater than a value in the same column, but not part of the selected range.
I can do it easily for one column but when I try to modify the vb code to select the new value for comparison (trying to use the active cell column) in order to use the same conditional formatting to subsequent columns the code won't work.
I'm pretty clueless when it comes to VB, so I'm guessing it's something simple. Any help is appreciated.
PHP:
' Macro3 Macro
' Macro recorded 2/4/2010 by sleep
'
' Keyboard Shortcut: Ctrl+f
'
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlGreater, _
Formula1:="ActiveCell.Column $1390"
Selection.FormatConditions(1).Interior.ColorIndex = 40Thanks,
-Tom
