In Excel, you can change the cell Color based on the value of another cell using conditional formatting. For example, you can highlight the names of sales reps in column ...
Read more
This post first appeared on Excel If Statement Multiple Conditions Range, please read the originial post: here