1
VBA format a cell based on range contents
I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. ‘assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As [...]
Answer Question
| May 20, 2009 5:11 AM
*RANGE, Conditional formatting, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. ‘assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As [...]
Answer Question
| May 20, 2009 5:11 AM
*RANGE, Conditional formatting, Excel VBA, Microsoft Excel, VBA, Visual Basic for Applications
1
