Question

  • Creator
    Topic
  • #2149286

    EXCEL DEFAULT SELECT FUNCTION HIGHLIGHT COLOR

    Locked

    by ishiosusan ·

    IN EXCEL, WHEN SELECTING CELLS, THE HIGHLIGHT COLOR IS GRAY. I WANT THAT DEFAULT SELECTION HIGHLIGHT COLOR TO BE LIGHTER. I DON’T WANT TO CHANGE THE BACKGROUND COLOR OF THE SELECTED CELLS.

All Answers

  • Author
    Replies
    • #2923118

      Clarifications

      by ishiosusan ·

      In reply to EXCEL DEFAULT SELECT FUNCTION HIGHLIGHT COLOR

      Clarifications

    • #2923051

      How to change the color palette for workbooks in Excel

      by Anonymous ·

      In reply to EXCEL DEFAULT SELECT FUNCTION HIGHLIGHT COLOR

      SUMMARY
      This step-by-step article explains how to change the color palette so that you can use custom colors for elements of the workbooks in Microsoft Excel. You can modify colors for many workbook elements, including the following elements:
      ?
      Worksheet Tabs
      ?
      Fonts
      ?
      Charts and chart elements
      ?
      Cells (fills and borders)
      This article explains how to change the color palette so that you can use custom colors for these elements.
      How to modify the color palette.
      Excel workbooks have a standard color palette for workbook elements. To modify the color palette for a workbook, follow these steps, as appropriate for the version of Excel that you are running.
      Microsoft Office Excel 2007
      1.
      Start Excel, and then open the workbook.
      2.
      Click the Microsoft Office Button, and then click Excel Options.
      3.
      Click Save.
      4.
      Next to Choose what colors will be seen in previous versions of Excel, click Colors.
      5.
      Click the color that you want to change, and then click Modify.
      6.
      Use one or more of the following procedures:
      ?
      To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color that you want.
      ?
      To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.
      7.
      Click OK.
      8.
      Repeat steps 5 through 7 as needed, and then click OK.
      9.
      Click OK to close the Color dialog box.
      10.
      Click OK to close the Excel Options dialog box.
      Microsoft Office Excel 2003 and earlier versions of Excel
      1.
      Start Excel, and then open the workbook.
      2.
      On the Tools menu, click Options, and then click the Color tab.
      3.
      Click the color that you want to change, and then click Modify.
      4.
      Use one or more of the following procedures:
      ?
      To replace the selected color on the palette with a different standard color, click the Standard tab, and then click the color that you want.
      ?
      To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.
      5.
      Click OK.
      6.
      Repeat steps 3 through 5 as needed, and then click OK.

      Please post back if you have any more problems or questions.

      • #2769013

        great tip, but may not be the answer to this question

        by kshelton ·

        In reply to How to change the color palette for workbooks in Excel

        Hi Peconet! That was a very useful tip. Unfortunately, I don’t think it solves the problem of highlighting only the range that is temporarily selected. The color of the cell background can be changed, but what I think the original poster is looking for is to change the default highlight color that Excel uses when a range of cells is selected for editing.

        I hope this helps to clarify. Please let me know if I’m wrong – I’m looking for the same answer. Thanks!

        • #2768988

          Seems to be a bit of an issue with Excel 2007

          by seanferd ·

          In reply to great tip, but may not be the answer to this question

          Normally, apps take their highlight color from the Windows Display Properties > Appearance > Advanced settings > Selected Items. Excel seems to ignore this (although other Office apps don’t), but the highlighting in previous versions was not hard to see.

          No known resolution to this that I’m aware of.

          The only options are to change the workbook background color to one that contrasts well with the highlighting, or change app background color in Display settings (which will change the color on all your apps).

          This seems to have caused much consternation for Excel users.

      • #2814938

        Finish save

        by rogeraia ·

        In reply to How to change the color palette for workbooks in Excel

        thanks for the info, only question is where to save it so it is the default in the future.
        excel 2003.

Viewing 1 reply thread