list two columnar values based on conditional formating (text color)

B

beechum1

I have a list of materials with:
material name, qty O/H, daily usage, weekly use, monthuse, yearuse.

the value of qty O/H will change color based on conditional formating,
which is just certain reorder points based on the appropriate usage #.
The color of a "to buy" material is red. At any time, i want a list in
another column of the materials and their qty O/H in order, without
spaces. Just point me in the right direction, i'll get the rest.
 
R

Roger Govier

Hi
If I understand your request correctly, you want to list qty O/H in
ascending order, then in cell G2 enter
=IF(ISERROR(SMALL($B:$B,ROW(1:1))),"",SMALL($B:$B,ROW(1:1)))
and copy down
 
B

beechum1

not in order of quantity, but in order that it's listed on the materials
list is fine. But in addition to the quantities (O/H) I also need the
corresponding material to be listed, so i know what i'm buying
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add values based on text color with the criteria of a date 7
Conditional Formating based on Date 1
conditional formating cells i Excel based on other cells values 3
Change background color using conditional formatting 4
color entire row by using conditional format 1
How can I add the values based the color of font and the date 1
Conditional Sum Based on Cell Background Color 6
Conditional Formatting - Formula based 4

Top