Hi all,
The perfect answer for my situation would be a formula, however i may
have to resort to code.
Any input appreciated.

In Col L (row 5 to 108) i have numbers, which through conditional
formating,
turn colors. If the color is Bold Blue, then i need that value put into
Col M, otherwise nothing.

IE: (in M1)
If(L1=Color is Bold Blue,L1,"")


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=488440