I want to color the cells of column F in my excel.
The criteria for coloring are values which are numerical.
The scheme for color is based on following schema
If a value lies on boundary i.e. 7 then it will be in lower range meaning
location taxi type avg lower limit avg upper limit color quantity location 1 gokia 5 7 Red 1 7 8 Yellow 0 8 9 White 2 9 Green 5 location total 8 location casanova 5 8 Red 0 8 9 Yellow 1 9 10 White 1 10 Green 52 location total 54 location orbit 20 30 Red 1 30 33 Yellow 1 33 36 White 14 location 36 Green 7 Total 23
gokia has 4 categories 5-7
7-8
8-9
9>
if a value is in column F is on boundary for type gokia example a value is 7 then it will belong to category 5-7
or if a value is 9 then it will belong to category 8-9. For boundary cases of values the category will be lower range.
Like this for Taxi type in column C values in F are different.
so all these cells in column F have to be colored Red,Green,Yellow,White
based on 4 categories.
The type of of taxi are gokia,casanova,orbit.
I want to automate this process of coloring as there is lot of data so each
time manually selecting and adding a filter is a time consuming work.
Bookmarks