Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
79
Views
Topic starter
Hi, need to understand the technique to step into/audit the function of SumIF so that it can highlight the entire range of cells fulfilling the condition(s) of a record.
For Immediate reference I am attaching the same workbook of Blog.
Posted : 20/03/2019 3:29 am
Hi,
Whenever you click into the formula bar to edit the formula, all the ranges used in formula will be highlighted, there is no way to highlight just a specific argument.
However, you can click on formula arguments to highlight that argument in your formula, as in the attached image.
Posted : 23/03/2019 1:54 am
