offlineimaging.blogg.se

(3.) From the Type drop down list, select the criteria that you want to use.(2.) Choose the find scope from the Within drop down, in this case, I will choose Selection.(1.) First, click the Values option icon.In the Super Find pane, please do the following operations: Select the data range that you want to find, and then click Kutools > Super Find, see screenshot:Ģ. After finding and selecting the matched cells, you can change the background or font color to your desired.Īfter installing Kutools for Excel, please do as this:ġ. Kutools for Excel’s Super Find feature supports lots of conditions for finding values, text strings, dates, formulas, formatted cells and so on.

Note: The Conditional Formatting is a dynamic feature, the cell color will be changed as the data changes. Highlight specific cells with font color: See screenshot: Highlight specific cells with background color: After select the background or font color, click OK > OK to close the dialogs, and now, the specific cells with value between 80 and 100 are changed to the certain the background or font color in the selection. Then, click Format button, in the Format Cells dialog box, set the background or font color as this: Change the background color by cell value:Ĭlick Fill tab, and then choose one background color you likeĬlick Font tab, and select the font color you need.Ĥ. 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.