I want to do a conditional rule, but can't seem to get it to work correctly. I want to compare Column F with Column C. If Column F does not match Column C, and it is not empty, I want it to highlight red. Issue is that when the below formula, some of the cells that match the value, it is still highlighting it red.
=IF($c2=$f2, 1, 0)
However, it is highighliting some items that matches as well as blank cells. Any ideas?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…