IF a cell is shaded?


New Member
Mar 7, 2019
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

Well-known Member
Oct 27, 2005
Office Version
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.
Last edited:


Well-known Member
Sep 21, 2016
Formula(s) may be possible - depends upon the criteria for shading.

Forum statistics

Latest member
Tommy O

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...