Comparing two columns

Options

Hello, i need help with a formula. I want to compare two columns and ideally either use conditional formatting or a helper "health" column

basically if Actual is higher than Metric: Red

if Actual is equal to or lower than Metric: Green

Either in the Health column or Highlight the Actual day


i was trying to use the below which i used in another sheet for a similar issue but it is coming back as unparseable

=IF(OR(Metric: Days in AR@row = "", [Actual: Days in AR]@row = ""), "", IF([Actual: Days in AR]@row < Metric: Days in AR@row, "Red", "Green"))

Answers