Forum Discussion
Formula
Hello, Looking to create a formula so that the overall tab column F where it says the name of the individual will pull into the individual tabs of the regions below. So when we fill out the ove...
I don't know what the condition is. Kinda need to know that in order to apply it, and I don't see what the basis is for the colors. (I see the words in column A, but not what in the data relates to that.
The colors are based on when someone is ready to be hired. And the name is colored to reflect the manual at the top for tracking purposes. I want the color to transfer with the filter formula over to the other sheets.
I know that's what you want. For conditional formatting to work, there needs to be a condition, in the data, that drives it. Are you just assigning the colors manually in the master sheet? If you are, may I suggest that instead of doing that in the master sheet, that you add a column of data in the master sheet where you select from a list (drop down) one of the characteristics that you've encoded in column A. THAT could become the basis for conditional formatting.