My first post on here so hopefully will be useful.
I am writing a validation program in VBA and I can't figure out how to use muitiple ranges and if statements within'. Here's my requirements:
- If a cell in column1 = 1 and on the same row column2 > 5 then colour that cell in column2 red
I have used "for each cell in range ..." in a linear way to apply speicific column validation but I can't work out how to cross column check.
Any help would be hugely appreciated.