Source Tab Name

[Carolann77]

I would like to use conditional formatting to color code my values based on the Tab name of their Source. For example if the value comes from the Import 1010 Tab i would like to have it be blue and if it comes tab Import 1020 I would like to have an orange background. Is this possible? If so how?

 

[6StringJazzer]

Are there formulas in the cells that you want to color? What do the formulas look like? If they are direct references like

='Import 1010'!C15

For newer versions you can use this rule:

=ISNUMBER(FIND(""Import 1010'",FORMULATTEXT(A1))

But I don't know of a built-in solution that will work in a version as old as 2010. Newer versions have the FORMULATEXT function but only starting with 2013. You would have to use a VBA user-defined function, and that means making your file macro-enabled. I can give you code if you want to go that direction.

Public Function FORMULATEXT(R As Range) As String

   FORMULATEXT = R.Formula2

End Function