![]() If you touch the arrow next to this, you can choose "Formula Is".Īfter selecting "Formula Is", the dialog box changes appearance. The Conditional Formatting dialog starts with the initial dropdown saying "Cell Value Is". In our case, cell A1 has a heading of invoice number, so I will select cell A2 and from the menu, select Format > Conditional Formatting. We want to set up conditional formatting for the whole range, but it is easier to set up a conditional format for the first cell in the range and then copy that conditional format. Here are the details on how to make that work. I suggested using conditional formats and the COUNTIF formula. How can I use Excel to mark the duplicates? Last night on Craig Crossman's Computer America radio show, Joe from Boston had a question:
0 Comments
Leave a Reply. |