When I put my cursor on an Excel worksheet cell containing a formula, then that formula nicely appears in the formula bar. Now when I put my cursor on the formula in the formula bar to edit it, Excel adds colors to different parts of the formula. Regretably those colors are almost all dark (dark blue, dark green,etc.), and I have great difficulty doing my editing.
Question: Can I disable the coloring or change the colors used?
Hi Cyberdude,
I just put a tick ' in front of the = sign, edit the formula, then take out the tick.
Originally Posted by Cyberdude
When I put my cursor on an Excel worksheet cell containing a formula, then that formula nicely appears in the formula bar. Now when I put my cursor on the formula in the formula bar to edit it, Excel adds colors to different parts of the formula. Regretably those colors are almost all dark (dark blue, dark green,etc.), and I have great difficulty doing my editing.
Question: Can I disable the coloring or change the colors used?
Dave
"The game is afoot Watson"
Hi, Piranha! Thanx for the reply. Your solution to my problem isn't what I was hoping for, BUT it works! I will be using your solution to advantage in the future. I DO appreciate the response.
Hi Cyberdude,
Yeah, it's pretty simple, i'm sure someone else will have a better solution. But as you say "it works". I'm happy to help you.
Dave
"The game is afoot Watson"
Posting Permissions
Reply With Quote
