There are no built-in Excel functions that return cells' background
colors. You would need to create a custom function to account for
those. It can be done but why can't the cells be flagged in some
value-based way, instead of using color. Perhaps with a helper column
(like an X in an adjacent column)? That way you could remain within
the realm of Excel's native functions and functionality: Flag rows with
an X and conditionally format impacted cells so they have a fill color.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=467475