EXCELISFUN1
New Member
- Joined
- Mar 11, 2019
- Messages
- 6
I've been able to find almost everything in Mr.Excel to help me with VBA in the past but I'm stumbling over this one. I'm a VBA newby; learning by examples and "can I's" then googling.
I'm adding this bit to a macro that is working perfectly.
I have two columns (H & I). I need to conditionally format the cell in column I highlighting in yellow if the amount in that cell is less than 130. I only want to do this if the value in column H is <> to 0. I need to do this from row 10 until the last row of the data in column A.
I already have the last row indicator set as
"Dim i As Integer' and I have coding to determine the last row.
Thanks for any help; I'm sure it's an easy thing but I'm having brain cramps today.
I'm adding this bit to a macro that is working perfectly.
I have two columns (H & I). I need to conditionally format the cell in column I highlighting in yellow if the amount in that cell is less than 130. I only want to do this if the value in column H is <> to 0. I need to do this from row 10 until the last row of the data in column A.
I already have the last row indicator set as
"Dim i As Integer' and I have coding to determine the last row.
Thanks for any help; I'm sure it's an easy thing but I'm having brain cramps today.