I have a worksheet that has conditional formatting setup for a data table (color scales) and another worksheet that houses INDEX/MATCH functions to return data from the data table. Is it possible, via INDEX/MATCH or otherwise, to also include the color of the cell from the conditional formatting?

Said another way: Suppose "Sheet1" returns a value of "100" in a specific cell using INDEX/MATCH, where that value on "Sheet2" is shaded dark green because of conditional formatting. As I have it set up now, INDEX/MATCH only returns "100" w/out the formatting.

The data is product-specific, so I can't use conditional formatting on "Sheet1" as well.