Note: In the above formula: C2 is the first cell of the column data that you want to highlight, and the data list!A2:A is the sheet name and list cells range which contains the criteria you want to highlight the cells based on.ģ. (3.) Then select one formatting from the Formatting style as you need. (2.) In the Format cells if drop-down list, please choose Custom formula is option, and then enter this formula: =match(C2,indirect("data list!A2:A"),0) into the text box (1.) Click button to select the column data that you want to highlight In the Conditional format rules pane, please do the following operations: Click Format > Conditional formatting, see screenshot:Ģ. Please do with the following steps to finish this job:ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |