same sheet formula references not highlighting
I can't seem to understand how or why my formula references sometime work and sometimes not. I use the simple [Column Name] and sometimes it works, sometimes not. Is there a trick to it that I am not seeing?
Its easier to reference another sheet because there is a way to simply select the appropriate column. Maybe there is a way to do this on the same sheet? something like Shift click or control click. I can't figure it out.
Help Article Resources
Check out the Formula Handbook template!