This will bring up a menu for you to build your rule. Instead of going to Highlight Cell Rules, go down to New Rule below Icon Sets. Select your cell range and go back to Conditional Formatting in the Styles section. However, its slightly trickier as youll start to use the COUNTIF function as well. You can expand the duplicate function to work with triplicates and above using some of the same steps. What about triplicates Maybe youre looking for a way to pair up data points and you need to eliminate third points. This is where you can decide how you want to format your duplicate cells. Go to Highlight Cell Rules and select the Duplicate values option. Now click on Conditional Formatting to open a dropdown menu.
0 Comments
Leave a Reply. |