Excel Highlight Color Background Color

Hey folks,
I usually just kind of lurk in here contributing when I can , but I think this is my second post in almost a year.

I am trying to get the background color of a cell in Microsoft excel 2004. Does anyone know how to do that? I have looked high and low and am unable to come up with an answer - even excel’s documentation isn’t helping.

I need to find out if a cell is red or if its green and then I’ll take action accordingly. I’ve tried style, back color, etc and no luck I always get a “Missing Value”


Thanks! that does it!