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
Check out the Formula Handbook template!