Hi!

Use the same logic that you used to apply the conditional formatting to
create a formula for column M.

Biff

"Desert Piranha"
<Desert.Piranha.1z56ey_1133072101.0322@excelforu m-nospam.com wrote in
message news:Desert.Piranha.1z56ey_1133072101.0322@excelfo rum-nospam.com...

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