Formula based on color

Good evening to all.
It's been a while and that's a good sign, hehe.
Well, the question I have is simple, the answer might well be as simple or not.
I have a list of numbers, usually from 1 to somewhere around 60. Usually, the background color is white. Sometimes, the background color is yellow, indicating something special. The cells / numbers and colors are copied and pasted from a website, so I have no influence in coloring the cells to begin with (I can change that, but I don't want to).
So, the question is: is there a possibility / formula / something that can give another cell a specific value, say 'Y', when the background color of another cell is yellow? I don't want that with white, only with yellow...
I couldn't come up with any formula in my head. If the answer is 'no', that's sufficient, too, of course, than I'll have to hand-pic the cells out. Just I like excel to do what it can so I don't have to do it, thus minimizing errors.
Thanks in advance!
Greets,
Dani螔.

Excel does not have anything built-in that you can use in formula based on color but it can be done with VBA. I can give VBA specifics if you provide a sample file to show exactly what colors are being used.

See attachment. This is the color yellow I'm referring to.

I have created a function called IsYellow in your file. I used it in a formula to show Y when a cell fill color is yellow. See attached.

Is it really that simple... Thank you!

Another option is the old Macro4 commands within a Defined name
In your example, with the active cell being C1
Defined Name BGCol = GET.CELL(38, Sheet1!B1)
Then in C1 copied down

Formula:

Please Login or Register  to view this content.

NOTE: Just like with VBA, you'd need to save the file as an xlsm file.

Thanks again. Going to try both solutions. See what's working best in my huge (I mean huge) file. :-)