Excel Filtering the cell with color


Good Day!


I want to filter filter  boxes  of products under following some conditions; like;

1. Up to 1000 boxes will be Green colored. 

2. 500 to 999 boxes will be Blue Colored. 

3. 200 to 499 boxes will be Yellow Colored. 


Can anyone share some idea, it will some huge time for me. 


Thanks in advance. 

4 Replies

@najim_uddin Use conditional formatting like in the attached file, though I believe you meant that boxes "from 1000 and higher will be green coloured".

but i want only product names will be colored based on boxes
best response confirmed by najim_uddin (Contributor)

@najim_uddin OK, then I misunderstood. See attached.

Thanks, Riny_van_Eekelen, for your support. It works.