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

Shelby Wilder

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! 😀

SmartLew

You'll need a helper column;

=if([Punch Weight(Oz/Yd2)]@row>[Punch Weight Spec High]@row,"Over")

Then, use this column for the conditional formatting