tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have conditional formatting in Column J (range J30:J130) using the Colour Series formatting giving me a colour heat map red to green
the annoying part is i cant get it to colour the rest of the lines (range H30:I130)
so what i need is a way for vba or more conditional formatting to colour the rows in (range H30:I130) the same as is next to them in J
Anyone know if this is possible and how to do it? (happy to change what i'm currently doing if need to)
Thanks
Tony
I have conditional formatting in Column J (range J30:J130) using the Colour Series formatting giving me a colour heat map red to green
the annoying part is i cant get it to colour the rest of the lines (range H30:I130)
so what i need is a way for vba or more conditional formatting to colour the rows in (range H30:I130) the same as is next to them in J
Anyone know if this is possible and how to do it? (happy to change what i'm currently doing if need to)
Thanks
Tony