openoffice conditional formatting number range

Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by Now only the cells greater than 90 are selected, keep selecting these cells, and then click the Bold button under Home tab to make them bold.ģ0-day) of this utility, please click to download it, and then go to apply the operation according above steps. Then a dialog box pops up to tell you how many cells are selected, click the OK button. In the Select Specific Cells dialog box, select Cell option in the Selection type section, and in the Specific type section, select Greater than in the drop-down list, enter the specific number into the textbox, and finally click the OK button.ģ. Select the range, and then click Kutools > Select > Select Specific Cells. The Select Specific Cells utility of Kutools for Excel will help you easily select the cells which are greater than certain number in a specified range at once, and then you can format them with bold font manually.īefore applying Kutools for Excel, please download and install it firstly.ġ. Make cells bold if greater than certain number with Kutools for Excel Then cells which greater than number 90 are formatted with bold font. Press F5 key to run the code, in the Kutools for Excel dialog box, select the range you need to format cells with bold font, and then click the OK button. Please change it based on your own needs.ģ.

Note: In the code, number 90 is the value you need to make cells bold based on. Set xRg = Application.Intersect(xRg, ActiveSheet.UsedRange) Set xRg = Application.InputBox('Please select a range', 'Kutools for Excel', xAddress,, ,, , 8) VBA code: Make cells bold if greater than certain number Sub BoldHighHours() Then copy and paste below VBA code into the Module window. In the Microsoft Visual Basic for Applications window, click Insert > Module. Press Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.Ģ. Make cells bold if greater than certain number with VBA codeīesides the above method, you can apply VBA code to make cells bold if greater than certain number in Excel.ġ. Then all cells which greater than 90 are formatted with bold font immediately in selected range. When it returns the New Formatting Rule dialog box, click the OK button. In the Format Cells dialog box, click Bold in the Font style box under Font tab, and then click the OK button.Ĥ.

Openoffice conditional formatting number range