Hi,
Hope I can find some insight here. I am working on highlighting cells in column Y and V $Y$2:$Y$35 / $V$2:$V$35 based on formula rule on $$AA2 values. Can anyone offer guidance on how to do this on VBA? Basically, if cells in AA2 do not = 0, are greater than or less than zero then I would need the respective V and Y column to become red. When I record myself doing the conditional formatting I am unable to get the code to yield highlighted cells. Additionally, my current way of highlighting it manually highlights cells that are blank :/ any insight would be much appreciated.
[/URL][/IMG]
Hope I can find some insight here. I am working on highlighting cells in column Y and V $Y$2:$Y$35 / $V$2:$V$35 based on formula rule on $$AA2 values. Can anyone offer guidance on how to do this on VBA? Basically, if cells in AA2 do not = 0, are greater than or less than zero then I would need the respective V and Y column to become red. When I record myself doing the conditional formatting I am unable to get the code to yield highlighted cells. Additionally, my current way of highlighting it manually highlights cells that are blank :/ any insight would be much appreciated.