veropcnet
Level 1 (44 points)
Applications

Q: Change Spreadsheet cell colors?

Good Day!

Can someone tell me how to change a cell or group of cells background color?

 

Thanks!

 

-Paul

MacBook Pro 15, Mac OS X (10.5.8), 2.4 Ghz, 6GB RAM, Unibody

Posted on Jul 8, 2012 6:29 AM

by veropcnet,Solvedanswer
veropcnet veropcnet
Level 1 (44 points)
Applications
A:

Hi Jiri,

No I was referring to the AppleWorks 6 Spreadsheet. Anyway I figured it out.

I clicked on the "Toolbox" icon on the lower left of the page, and then clicked on the "Color Pallette" button from the toolbox toolbar that popped up.

Posted on Jul 8, 2012 6:58 AM

Close
veropcnet

Q: Change Spreadsheet cell colors?

  • All replies
  • Helpful answers

  • by Jiri Krecek,

    Jiri Krecek Jiri Krecek Jul 8, 2012 6:39 AM in response to veropcnet
    Level 4 (1,075 points)
    Jul 8, 2012 6:39 AM in response to veropcnet

    Are you referring to the Numbers app?

  • by Jiri Krecek,Helpful

    Jiri Krecek Jiri Krecek Jul 8, 2012 6:39 AM in response to veropcnet
    Level 4 (1,075 points)
    Jul 8, 2012 6:39 AM in response to veropcnet

    In case you are indeed referring to Numbers app:

     

    1. Highlight the cells
    2. Press OPTION_COMMAND_I to show the inspector
    3. Go to the 4th tab from right for Graphic settings
    4. Choose fill type from drop down (solid, gradient, etc...)
    5. Click on the rectangle beneath it (red I my case, white in your case)
    6. It will open colors pallette - pick a color

    Screen Shot 2012-07-08 at 8.34.27 AM.png

     

    You can also achieve the same by adding the color fill pallette icon by customizing your toolbar

  • by Jiri Krecek,

    Jiri Krecek Jiri Krecek Jul 8, 2012 6:42 AM in response to Jiri Krecek
    Level 4 (1,075 points)
    Jul 8, 2012 6:42 AM in response to Jiri Krecek

    Here is the second approach, if you can see the FILL button in the toolbar - red in my case, off to the right.

    Select cells, click this buttona dn a small pallette will pup up.

    If you want to remove a color, choose the white color which has a red diagonal stripe across.

    Screen Shot 2012-07-08 at 8.40.24 AM.png

  • by veropcnet,Solvedanswer

    veropcnet veropcnet Jul 8, 2012 6:58 AM in response to veropcnet
    Level 1 (44 points)
    Applications
    Jul 8, 2012 6:58 AM in response to veropcnet

    Hi Jiri,

    No I was referring to the AppleWorks 6 Spreadsheet. Anyway I figured it out.

    I clicked on the "Toolbox" icon on the lower left of the page, and then clicked on the "Color Pallette" button from the toolbox toolbar that popped up.