Re: Highlight Formula Reference On Another Sheet
ok...will do...can you please let me know if it is possible to automatically revert the formatting changes made by this macro?
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
Re: Highlight Formula Reference On Another Sheet
ok...will do...can you please let me know if it is possible to automatically revert the formatting changes made by this macro?
Re: Highlight Formula Reference On Another Sheet
thanks for replying but I would rather hear something more constructive about the problem at hand..I am aware of all layout-complexity interplay that affects the worksheet....CTL+Z DOESNT WORK!!!
Re: Highlight Formula Reference On Another Sheet
cool...it works! is there a way to undo cell coloring? thanks!
Re: Next Greatest Maximum
superb..what is for minimums - small?
Hi!
I want to ask if there is a way to find the next greatest maximum without a ton of auxiliary coding....Is there a function which does that in Excel? For example from the following list it would give 45:
1
34
45
26
78
29
7
Thanks! a still more awesome function would give 34 if you give it 2 as an input parameter.
Re: Highlight Formula Reference On Another Sheet
Quote from Ger Plante
thanks!!! it works now!! but, strangely, it uses a1 cell as its starting point instead of the current active cell...do you think you can make it start from the current active cell instead of the a1? also - do you know if it is possible to revert format changes after the macro is run?[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]
Quote from Cheeky CharlieI have to admire your tenacity. You should be in business, not research.
If you are not referring to Ger - thanks! I am actually in business too....
Re: Highlight Formula Reference On Another Sheet
thanks for the code Dave but I get these two lines highlighted in red with the syntax error:
Can you please check if this is correct?
Also - does this code allow to bring the cell formatting back once the cells have been colored?
Thanks!!!!!
Re: Optimal Combination Model With Constraints & Variables
thank you!!! that was a very insightful reply...
Re: Highlight Formula Reference On Another Sheet
Quote from shgAttached.
thank you for making this for me...as I see the cells in the second sheet are actually not highlighted,,,,even if the popup window shows their links....looks like there is no hope in this question.....((([hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]
Quote from Cheeky CharlieIMHO the best you can do would be the Goto precedents/dependents which Hatman has alluded too (press Ctrl + G whilst on the cell in question and pick your poison).
What you're asking for is more about the design of Excel itself than how to use it - we can't really fix that here!
Perhaps some git with 2007 will wade in to tell you how fantastic that is for exactly what you need(?)
yep..I was just thinking that this was not such a huge problem and an average addin or a smart method would quickly overcome it....
Re: Highlight Formula Reference On Another Sheet
cool....I hope it wont sound very outrageous...but do you mind making a screenshot of your workbook when you have the cells highlighted? I need this to make sure we understand each other....thanks!
Re: Highlight Formula Reference On Another Sheet
thanks for clariying...I do not doubt that clicking a dashed line is possible I am just saying that it doesn't help me to solve the problem...thanks!!!
Re: Highlight Formula Reference On Another Sheet
Dave, a post ago you said it cannot be done...now I am confused....((
Re: Highlight Formula Reference On Another Sheet
thanks...but it doesnt work...does it work for you???
Re: Highlight Formula Reference On Another Sheet
thank you for your reply...i need this formula highlighting to visually "debug" or check the code as I programm the model in excel...unfortunately I already tried the method you proposed and it didnt work...(((
Re: Highlight Formula Reference On Another Sheet
thanks....maybe you can recommend any excel plugin which extends the functionality of the standard compare-side-by-side tool in Excel 2003?
Re: Formula Highlighting On Different Sheets
thank you...:).....I still hope someone here experienced the same problem and will be able to help me............
Re: Formula Highlighting On Different Sheets
i very much appreciate your stubbornness...)) as a matter of fact I am myself a formula-only man....no vba knowledge at all!!!))) which I do not regret at all at the time being....as for my purpose for so many columns...I can only slighty remove the veail - this is a scientific project for constructing a complex adaptive model of a natural phenomen...sorry cannot go any further from that!)) anyways....if you get an idea on my topic problem - please let me know!
Re: Formula Highlighting On Different Sheets
thanks again..but I do not think i can make this question more general I just need to see formula references highlighted on different sheets (while having two different sheets of the same workbook open at the same time side by side) as they are on a single sheet..looks like I have run into a insurmountable wall here....
Re: Formula Highlighting On Different Sheets
thanks a lot for such a detailed reply! I tried all the approaches you suggested and none of them works for me...((( in all cases Excel takes me to the cells that are referenced by the formula while I need them to be highlighted only. I ask this because I am building calculations on one sheet based on the calculations in the other. I am using two sheets because one of them is already full of columns with the formulas...)) Is there absolutely no way to get Excel highlight formulas on different sheets???? Maybe some pluigin does this??