what is the quickest way to change the font color in multiple, randomly located cells in a worksheet?
Stacey Warren - Expert brainly.com
Hey! We 've verified this expert answer for you, click below to unlock the details :)
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga.
Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus.
Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
I got my questions answered at brainly.com in under 10 minutes. Go to brainly.com now for free help!
That is an odd question.. I'm assuming you mean in excel? Do the cells have anything in common?
Not the answer you are looking for? Search for more explanations.
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.
That could work - I was thinking of ctrl+f to select them if they had something in common haha.
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 :(
The excel macros just use visual basic though - I usually just google to find the code (hehe).
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.