#WHY DO ALL CELLS UNDERLINE IN EXCEL HOW TO#
#WHY DO ALL CELLS UNDERLINE IN EXCEL CODE#

To apply a single underline, click Underline. On the Home tab, in the Font group, do one of the following: You can also press F2 to edit the active cell, use the arrow keys to place the insertion point, and then use SHIFT+arrow keys to select the contents. Underlining of information within cells is handled by displaying the Home tab of the ribbon and, within the Cells group, clicking the down-arrow to the right of Format and choosing Format Cells. If editing in a cell is turned off, you can click the cell and then select the text or numbers that you want to underline in the formula bar. If editing in a cell is turned on, you can select the cell contents by double-clicking the cell. To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline.

You can do the same for C2 and D2 if you want them to be based on cells A2 and B2 respectively.To underline all text or numbers in a cell or range of cells, select that cell or range of cells. Now the conditional formatting is also applied to cell D1, based on the values in B1. You should now have your formatting for cell C1.Ĭopy cell C1, select cell D1, and Paste Special (under the Home ribbon, choose the Paste dropdown, the Paste Special) formats. You'll be back in the New Formatting Rule box. In the box under Format values where this formula is true, type (without quotes) '=C1>A1'Ĭlick the box that says 'Format.' - in the box that opens, you should be able to select Bold under 'Font style' and then there is a separate box for 'Underline', choose 'Single' here. Go to the Conditional Formatting dropdown on the Home ribbon, hit 'New Rule.'įor Select a Rule Type, choose 'Use a formula.' Here are steps that I took to get it, let me know if you have any issues. how do I 'apply' the conditional formatting to the cell that already has numbers in it ? The cells currently have numbers in all of them. Cell ends at being BOLD & UNDERLINEĪnd so on. If C2>B2 change the format of C2 to BOLD & UNDERLINE (this is true of this case, 400 > 370). IF C2>A2 change the format of C2 to BOLD (this is true of this case, 400>81) Cell ends at being NOT bold and NOT bold & underline. If D1>B1 change the format of D1 to BOLD & UNDERLINE (this is NOT true of this case, 0.780 is not > 9.6).

IF D1>A1 change the format of D1 to BOLD (this is NOT true of this case, 0.780 is NOT >1.2) Select the whole data and choose the All Border option under the border. First, select the header field and make it bold. Now we will do data formatting in excel and will make this data in a presentable format. If C1>B1 change the format of C1 to BOLD & UNDERLINE (this is NOT true of this case, 1.5 is not > 9.6). We have the above-unorganized data, which is looking very simple. Task: If/Then conditional formatting to make a number cell bold or bold&underline based on if it is > or A1 change the format of C1 to BOLD (this is true of this case, 1.5>1.2)

#WHY DO ALL CELLS UNDERLINE IN EXCEL HOW TO#

I tried looking up how to do this but my apologies if it is easy to find. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.

#WHY DO ALL CELLS UNDERLINE IN EXCEL CODE#

NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Why do all cells underline in excel