Gembree--

Thanks so much for replying! I figured I would never get an answer. I've been copy and pasting my formatting to word and copying them back in, but I really hope i can get the Function from your link to work.

Hoping you could answer a couple of quick questions for since this is on your radar..

1. For Rick's function, and other functions in general, i can't: When someone deems a function as NOT a UDF, then what is it? What i mean is, if it's not a UDF then how is the function called?

2. For the function, and other functions in general, is this the correct process to get it the work correctly? (Sorry, I've really tried to find a straight forward answer to this but haven't been able to get a clear response):

1. Copy/paste the code below into a "New Module" via VBA editor

Code:
Function getColorIndex()   
getColorIndex = ActiveCell.Interior.ColorIndex
End Function
2. Return to relevant workbook/spreadsheet, and for all cells with conditional formatting, type: "=getColorIndex()"? OR do I need to fill in the values with the ()? If so, what would those values be?

If that's the correct way to do this then can I just copy and that cell to all relevant cells and it should spit out the actual fill color, which I can then copy and paste to other excel docs?

Sorry for the really annoyingly basic questions. I'm by no means an expert at any of this.. just trying to make better use of my time.

Thanks in advance for any help!!!!