Conditional Formatting

Originally Posted by daddylonglegs

OK, I tried giving the table a defined name (rather than using the actual table name) - I selected whole table and used Name Manager on formulas tab to rename the table New_Table_Name and then I used this formula in CF

=AND(X16<>"",X16+0<VLOOKUP($C$6,New_Table_Name,3,0))

see example attached

Now thinking that your table includes "Ingredient" too that can alter specifications....does that make any difference?

That is it!
Hit the nail on the head with that, works great!

I am guessing there wouldn't be any way of incorporating the higher limit in as well?

The columns within that block that need the Conditional Formatting applied to them are:

ACEL
Mo - Moly
Cu - Copper
C - Carbon
P - Phosphorous

Thanks for all of your help so far, I am very grateful!

With regards to the "ingredient" column, what table is that in? The "GradeSpecs" worksheet?
If so, the ingredient is what refers to the column on the "1" worksheet that data is being inputted into, so there are different limits for each ingredient.

The little list above demonstrates what letters correspond to what ingredient.

After a bit of testing, the limits change when the grade changes, which is 100% correct, but the limits do not seem to be correct for the "Carbon" element in the grade "JU12A".

Thanks,

Nick