In the dialog box that opens, set the color in which you want the row to get highlighted.In the formula field, enter the following formula: =$C2=”Bob”.In the ‘New Formatting Rule’ dialog box, click on ‘Use a formula to determine which cells to format’.In the Styles group, click on Conditional Formatting.Select the entire dataset (A2:F17 in this example).Suppose you have a dataset as shown below and you want to highlight all the records where the Sales Rep name is Bob. Highlight Rows Based on Drop Down Selection.Highlight Rows in Different Color Based on Multiple Conditions.Highlight Rows Based on a Multiple Criteria (AND/OR).Highlight Rows Based on a Number Criteria.Highlight Rows Based on a Text Criteria.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |