Formula for looking up cells based on cell colour

[Jon Johny]

Is it possible to write a formula that pulls data based on the colour of a cell. For example, I have a chart with conditional formatting and I want to have a seperate chart to the side which pulls only the data from the first table for cells highlited yellow.

Thank you,

 

[Jon Johny]

Does anyone have any solution for this?

 

[c_m_s_jr]

Couldn't you just use the same formula you are using for conditional formatting but have it return the cell value?

 

[Jon Johny]

I dont believe you can?

I dont beleive you can have a formula that says retrieve info in cell A2 if cell is coloured 'yellow'.

However, I am not 100% certain, as well there may be a different way to go about it altogether.

 

[c_m_s_jr]

What formula are you using to determin ig cell A2 is yellow?

 

[Jon Johny]

Im using a co ndiotnal format formula that says if a2=d2 then make a2 yellow.

 

[c_m_s_jr]

Im using a co ndiotnal format formula that says if a2=d2 then make a2 yellow.

So why couldn't you do:

=IF(a2=d2,d2,"")

???

Then the only values populated for your chart will be those that equal each other.