Override a Conditional Formatting threshold with a second?

[creationracing]

Good evening all!

I've got a query that I've been racking my brain over for a couple of days, and for which there is probably a simple solution, but it's just evading me.

So, I've got a sheet of simple data, monitoring the decay of battery cells over time. If they fall below a certain value, they're judged to have failed and are conditionally formatted red and bold against a limit figure. All very easy so far.

However...

Just occasionally there's a different kind of battery in the test group, for which the limit figure would be different. I've added an extra column to the right of the data table, where I can manually add the limit figure for any "oddball" batteries that are encountered. The different value in the extra column would apply to the whole row.

I've tried a few things to get this extra figure to "override" the minimum limit applied to the whole table, but it's defeating me. The "Stop if True" function unfortunately doesn't work how I want it!

See a simplified version of test sheet attached.

Any help would be gratefully received!

Thanks in advance,

Roy K.

[JohnTopley]

Try

CF1 (Highest priority)

=AND($L4>0,B4<=$L4)

CF2

=AND($L4=0,B4<$D$2)

[creationracing]

Wow. I was waaaaay overthinking that.

Thanks for the solution, I'll go stick the dunce cap on for a bit.

Cheers!