So here is my issue, I've got a quantity in coloumn O and another in column Q.
What I've trying to write is conditional formatting that will look at the quantity in coloumn O and if less then Zero will then look in column Q, if this is Zero then line to stay the same text colour.
However, if there is a amount less then zero in both coloumns I need the line text to change red.
Any help would be greatly appreciated.
Bookmarks