, Good afternoon.
You must use the Conditional Format to have what you need.
to apply the CF.
Menu Conditional Format
Select colour format as desired
Please, tell us if it worked as you desire.
I hope it helps.
Belo Horizonte, Brasil