Remove highlight background in cell

D

DTTODGG

Hello-

Is there an easy way to remove the "highlighted yellow background" in all
cells in all worksheets of a workbook, but leave the data in the cell?

So, change "yellow highlight" to "no fill" - but leave the cell contents?

Thank you so much!
 
P

Paul B

Dttodgg, Ctrl+A to select all cells in the sheet, then click the drop down
arrow next to fill color button and select no fill
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert shading to highlighting for specific colors 8
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Word doc keeps changing to ALL CAPS 0
How to copy cells by collor code 0
formula(s) for creating new sheet comprised only of highlighted cellsfrom another sheet? 3
Conditional Formatting to Another Cell 0
Excel does not accept text format! 0
Remove Hyperlinks Without Changing background shading 14

Top