Forum Discussion
Solved
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.
najim_uddin OK, then I misunderstood. See attached.
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
najim_uddin OK, then I misunderstood. See attached.
