If the color of the cells change because of the conditional formatting, you can later re-sort the table and you will have no problems. Using the second drop-down list under Order, specify whether you want the red font cells to be on the top or bottom of your list.
Using the Order drop-down list, select the color you would like to sort by (red).Using the SortOn drop-down list, select Font Color.Using the Sort By drop-down list, select Column A (where your conditional formatting is applied).We don’t offer a course for Excel 2011, but we do offer a complete course for Excel 2016 for Mac. Click the Sort tool to display the dialog box. Like Excel 2010 for Windows, this was also the 13th version of Excel for Mac, but version 13 was skipped for superstitious reasons and Excel 2011 was declared to be version 14.Select all the cells you would like included in your sort.He wanted to be able to sort by that color.įortunately, that is not all that difficult to do.Īssuming that all your data and conditional formats are already set up, follow the steps below to learn how: Please do as follows: Kutools for Excel- Includes more than 300 handy tools for Excel. He had created a conditional format such that any data that was in column A and also in colum B, would turn a bolded red color. If you have Kutools for Excel installed, you can apply its Select Same & Different Cells feature to easily apply conditional formatting based on VLOOKUP and matching results in Excel. It seems he had a list of data in column A and one in Column B. A client recently e-mailed me inquiring about filtering in his Excel worksheet.
0 kommentar(er)
