How to change cell colors automatically? | Excel 365

Select column. Go to Home tab. Under Styles section choose Conditional Formatting.

Home 
Insert 
Page Layout 
Calibri 
Font 
Formulas Data 
Review 
-¯jsj 
View Help 
Wrap Text 
Merge & Center v 
Alignment 
General 
Number 
/ConditiondI 
Format as 
Table v 
Normal 
Calculation 
Format Painter 
ipboard 
Bad 
Check Cell 
Styles

Choose Highlight Cells Rules and then Between…

Normal 
Conditional Format as Calculation 
Formatting v Table v 
Bad 
Check Cell 
Expla 
Highlight Cells Rules > 
Greater Thanm 
lop/ Bottom Rules 
Rule... 
Clear Rules 
Manage Rules... 
Less 
Equal Tom 
Text that Containsm 
A Date Occurringm 
Duplicate Valuesm 
More Rules...

Define range that should be colored.

Between 
Format cells that are BETWEEN: 
and 7 
with 
Light Red Fill with Dark Red Text v

Under format selection choose Custom Format…

Under Fill tab choose suitable color and click OK

Confirm formatting by clicking OK.