Created attachment 199388 [details]
Sample spreadsheet for easy testing

Please use the attached sample document I created to easily reproduce the problem.

Using named ranges of cells or whole columns (such as "amounts_column" and "taxes_column" or "amounts_cells" and "taxes_cells"), if you reference them in a formula, LibreOffice 25.2.0.3 and older cannot highlight those ranges with a color code in the formula and in the spreadsheet, unlike if you were manually referencing the cells (ex: $A:$A, or $A2:$A5).

Demonstration video also included for your convenience to see exactly how to test it, showing which parts work and which parts don't work.

----------

Tested on:

Version: 25.2.0.3 (X86_64) / LibreOffice Community
Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Flatpak
Calc: threaded