I am trying to highlight duplicates in a row and am using the explanation:
Highlighting Duplicate Entries
Our first task is to highlight the cells in Range1 that are duplicates. We
use Excel's Conditional
Formatting tool to accomplish this. First, highlight the entire Range1.
Then, select the
Conditional Formatting tool from the Format menu: Format->Conditional
Change the "Cell Value Is" option to "Formula Is" and enter the following
formula in the
formula text box:
Where A5 is the first cell in Range1. Then,
click the Format button and
select the font or
color you want your cell formatted with. Finally, click OK. Duplicate
entries in Range1 will be
formatted as you selected. For example, if "Able" occurs twice in Range1,
occurrences of "Able" will appear highlighted.
I am changing "A5" to the first cell in the row and still nothing
what am I doing wrong?