As per attached sheet example email outlook. Excel conditional formatting relative reference not working.

320 vs 520. Held for ransom book.