Excel

Conditional Formatting

Select columns

Click on "Conditional Formatting" from the Home tab

Select your rules