I tried. I really, really tried. But #librecalc is bad. Especially using conditional formatting with multiple rules.
I'm sad because I really like #librewrite and hoped Calc would be of similar quality.
I think I have to go back to Google Sheets which is definitely better than Excel for anything other than really large spreadsheets.