Hi @sammeredith, welcome to the forum.
Here’s a workflow that should get you started.
Conditional formatting isn’t really a thing in KNIME unless you’re going to be exporting to Excel. In that case, you’d use the XLS Coloured Writer node and specify your conditions.