Learn how to use single color formatting that is part of the conditional formatting rules.
In our example we show how to get all the cells in a row to be highlighted, that has a certain value.
Also find out how to delete duplicates in easy fast way