When I was in college there was a way to view all the cells in a formula by selecting some key or series of keys on your keyboard that would highlight the corresponding cells of a formula.
For example, using the formula =IF(C18>C24*1.025, "Sell $5K", ""), isn't there a way to hit a key or series of keys on the keyboard when you are in the cell with this formula and then all the corresponding cells in that formula (C18 and C24) will get highlighted?
I don't know what effect this will have but try to select a cell with a formula in it and press F2.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Ctrl-[ (that's Ctrl-open-square-bracket)
http://www.pcmag.com/article2/0,2817,2387013,00.asp
but later versions of excel 2013 and 2016 already does that if you click in the formula bar also while editing - shows different colours
not sure if 2010 di
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
F2 did the trick. I knew it was something simple. Thanks
You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks