I have a spreadsheet that uses VLOOKUP to read values from an external spreadsheet. There are two columns with color scale conditional formats (red, yellow, and green). After recalculating, the cell values update fine, but the conditional formats contain only red and green. Yellow is missing. If I close and reopen the spreadsheet the conditional formats are correct–yellow is there. Is this a bug? Is there a macro command I can call to have the conditional format refresh correctly without reopening the file?
Please edit your initial post and add the Calc version (menu Help > About LibreOffice).
What happens when you perform a hard calculation (Ctrl + Shift + F9)?
If you can add a file without sensitive data (7th icon on the message tool bar).