![]() 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. |