I don't think this is possible without VBA but feel free to prove me wrong. Looking for a conditional conditional formatting.

https://www.excelforum.com/excel-for...formattng.html