Conditional formatting - Highlight duplicate values

[crag8119]

Hi ,

How do I highlight duplicate values is columns O and P only , so if the Value exists in O and P highlight it. I don't want to highlight cells with no values.

Thanks

 

[mole999]

Re: Help with conditional formatting - Highlight duplicate values

you should be able to just set up the CF. select the two columns, click conditional format in the ribbon > Highlight Cell Rules > Duplicates