I think these issues may be because of administrative controls on macros. If I have a xlw/py script which opens excel, commands xlw to open a file, and run a macro, it gets blocked. However, if I (1) start Excel
excel Excel Online Formulas and Functions Macros and VBA office 365 Like 0 Reply View Full Discussion (4 Replies)Show Parent Replies Michael Kwakye Copper ContributorFeb 19, 2018 Thank you for your response. Yes this would however it leads me to another problem.I have entered the formula into...
To automatically change bar colors in a chart based on conditions, use conditional formatting in spreadsheet software like Excel or Google Sheets. Select the data series and create a rule with a formula that triggers a color change when a condition is met (e.g., =A1=0 for ...
In column B I want to enter data manually if the corresponding cell in column A is either"single target" or "double target". However if the cell in Column A is "Loss", I want to use a formula. How enter this in excel? Hello, well, you could use a formula and overwrite it manual...
Michael, either you use VBA - which I can't help you with - or you use two helper columns: one with the formula and the second for the manual input. In the final column you put them together: =IF(Column_with_Input)<>"",Column_with_Input,Column_with_formula) ...
well, you could use a formula and overwrite it manually, something like =if(A1="loss",YourFormula,"") Copy down. Now only the cells where column A has "loss" will show the result of your formula, and you can manually type over the formula in other cells. ...
well, you could use a formula and overwrite it manually, something like =if(A1="loss",YourFormula,"") Copy down. Now only the cells where column A has "loss" will show the result of your formula, and you can manually type over the formula in other cells. ...
Hello, well, you could use a formula and overwrite it manually, something like =if(A1="loss",YourFormula,"") Copy down. Now only the cells where column A has "loss" will show the result of your formula, and you can manually type over the formula in other cells. ...
Hi Everyone, I am trying to solve a problem Lets say that cells in Column A contain either "loss" "single target" or "double target" In column B I want to enter data manually if th... Michael, either you use VBA - which I can't help you with - or you use two helper...