Spreadsheet conditional formatting not working

OS version: Kubuntu 24.10
App version: 8.3.0.97
Downloaded from: Flatpak
Additional information: Setting up a simple spreadsheet to breakdown my Costco purchases into categories for inputting into ActualBudget. For a couple of cells that do simple sum functions I created conditional formatting on them to change cell color if they equal the value of another cell (which I manually input the value of at the start of each edit). The formatting is not changing even though the value is matching what the hard coded reference value is. The cells are formatted as Numbers. Not sure why this isn’t working. Any ideas?

Onlyoffice2

Nevermind I figured this out. Have to make it a Formula rule and create one that equals the value of the formula then another that has a not equal to formula.

1 Like