Quantcast

Got Homework?

Connect with other students for help. It's a free community.

  • across
    MIT Grad Student
    Online now
  • laura*
    Helped 1,000 students
    Online now
  • Hero
    College Math Guru
    Online now

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

tylerb23 Group Title

what is the quickest way to change the font color in multiple, randomly located cells in a worksheet?

  • 2 years ago
  • 2 years ago

  • This Question is Open
  1. TranceNova Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    That is an odd question.. I'm assuming you mean in excel? Do the cells have anything in common?

    • 2 years ago
  2. 142343 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    i would say i will give u a exmaple give me a min

    • 2 years ago
  3. 142343 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    right click

    • 2 years ago
  4. Notalgebrasmart Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    If you select the various cells all at once, then go to Format and then Font, then Select Font Color to change the color of the font.

    • 2 years ago
  5. 142343 Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    yea

    • 2 years ago
  6. TranceNova Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    That could work - I was thinking of ctrl+f to select them if they had something in common haha.

    • 2 years ago
  7. agdgdgdgwngo Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    I think you can write a macro that does these kinds of things. I've never coded any macros (or used excel) to know how to do such a thing myself though :(

    • 2 years ago
  8. TranceNova Group Title
    Best Response
    You've already chosen the best response.
    Medals 1

    The excel macros just use visual basic though - I usually just google to find the code (hehe).

    • 2 years ago
  9. waybeyond Group Title
    Best Response
    You've already chosen the best response.
    Medals 0

    To do so in Excel or OpenOffice Calc, you can hold down the Ctrl key when you left mouse click. This will allow you to select non-contiguous cells. Then you can click the font color change button on the toolbar. If you don't have that, you can also change the cell property and select the color for the font.

    • 2 years ago
    • Attachments:

See more questions >>>

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.