I need to create a formula which colours excel fields when the same text is found on two different tabs. For example on one sheet i have the text - BOWDOL, so when this appears on both sheets, it would highlight the field in a colour.
Solved by A. L. in 11 mins