Comparing two columns

ldavenportHAP

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"))

Paul Newcome

It looks like you just forgot your square brackets around the Metrics column references the same way you have them around the Actual column references.