Conditional Formatting Based on another Cell in the Row (Lab Specs)

Hello! I am looking for a way to make the lab result column values red if they are over the value found in the spec column.

  • There are multiple fabrics each with different spec.
  • They are all being tested in the same manner with the results in a singular column.
  • A VLOOKUP pulls in the spec based on fabric chosen in fabric column.

I would like the result column number to turn red if it is over the amount in the spec column,

Conditional Formatting doesn't seem to work because it can reference a value@row from what I can tell.

Example: I would like the two cell values designated by the red arrows to turn red because they are over the amount in the Punch Weigh Spec High column.

Thank you! 😀


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!