Thread: [Solved] Bulk formula change
View Single Post
 
Old 10-26-2014, 09:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,915
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Maybe it would be advisable to be able to access the error values easily for the future. You could use conditional formatting to make error messages the same colour as the background. It would then be easy to review them just by changing the formatting to a visible colour if needed.
For example if your formula does not return a value just because of an invisible space or so, you could loose valuable information
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote