![]() ![]() In the third and fourth box, enter the filter conditions, such as 80, 100.ģ.In the second drop down box, select the criteria: between.In the first drop down box, select the Cell Value.In the New Formatting Rule dialog box, select the Format only cells that contain item in the Select a Rule Type box, and in the Format Only Cells with section, specify the conditions that you need: Select the range of cells that you want to highlight certain cells, and then click Home > Conditional Formatting > New Rule, see screenshot:Ģ. Supposing you have a range of data, and now you need to color the values between 80 and 100, please do with the following steps:ġ. The Conditional Formatting feature can help you to highlight the values greater than x, less than y, or between x and y.
0 Comments
Leave a Reply. |