I have LibreOffice 220.127.116.11, MS Edge, Windows 10, HP laptop [A6].
I use cell background colours to highlight different types of journal entries in a calc spreadsheet.
I use colour values from CELL_BACKCOLOR(SHEET();ROW();COLUMN()) in functions SUMIF and COUNTIF.
Which is OK if I don’t change the colour scheme or correct a colour because the colour values don’t update.
If I delete the original CELL_BACKCOLOR reference and retype it then it picks up the new value correctly.
But I don’t want to do that through the whole journal.