IF a cell is shaded?

[billyphatu]

Hello,
Long time lurker - thanks for all the great solutions and tips that I have harvested from this forum so far.

My question is: Is it possible to use use the IF function to react to whether a cell is shaded, and shaded a certain colour?

Context: I have a budget template document with many cost lines across several sheets. I have a particular budget that is shared with another party. The other party is responsible for covering certain specific costs, and so to identify those costs, I have highlighted them all by shading the appropriate cell with a consistent colour. Now what I would like to do is to gather all of those figures in one place for a total of just those expenses.

Or, is there another way to do this that doesn't involve shading?

Thanks for all advice.

 

[Michael M]

With a simple IF...No !
But you could use VBA to put all of those lines onto a seperate sheet to give to the other party, OR do calculations with !
If this was an option you would need to provide cell color, the column the colored cells were in AND which sheets held these colors, unles of course you simply wanted to check ALL sheets.

 

[footoo]

Formula(s) may be possible - depends upon the criteria for shading.