The issue is the numbers under column J. Since the Match is looking up the last value in J and that's on a lower row than the last value in B, you get differing data ranges. You have three options:
1. Move the data under J somewhere else.
2. Adjust the ranges manually.
3. Change the last Match to read off B:B instead of J:J. Note that any data put under B might then throw off your calculations or result in an error, depending on what was in that data and the corresponding value in J.
I don't see any change to your conditional formatting. It's working for me.
I didn't bother checking the first time whether your data was from formulas or not. For J, since it is a formula, adding 0 or multiplying by 1 makes no difference, since any formula will try to coerce a number stored as text into a number. For the dates, it might have made a difference, but if this is your real spreadsheet, it appears Excel is reading those correctly as numbers.
Bookmarks