Hi,
Looking for a formula for the following please.
I have 2 columns - debits and credits. What I want is a conditional format that will look down both columns and highlight duplicate entries within both columns.
The end result being either cells that don't match either formatted a colour or left as 'no fill'
Many thanks,
Looking for a formula for the following please.
I have 2 columns - debits and credits. What I want is a conditional format that will look down both columns and highlight duplicate entries within both columns.
The end result being either cells that don't match either formatted a colour or left as 'no fill'
Many thanks,