Biff Wrote:
Making a value, a certain color, is easy.

There's your solution (if you think about it!)

Answer this question:

Why are you making the value a certain color?

Because it's 0? Because it's <100? ???

Biff

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

Biff Wrote:
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
Hi Biff,
Thx for your input.
Making a value, a certain color, is easy.
Making a color, a certain value, however escapes me.
Sooo i am going to sleep on it. Some of my best work is from
dreaming.


--
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
Hi Biff & Bob,
Ok, got 3 hours sleep and reading your & Bobs posts the light finally
went on.
The numbers in Col L have Conditional Formating turning them Blue Bold
if that
number is found in a range
'=COUNTIF($G5:$K5,$L5)

Before I was thinking i had to have Col M go off of the color, in Col
L.

BUT the color really has nothing to do with it. So i used an IF formula
in Col M
with the same criteria as is in the Conditional Formating of Col L
'=IF(COUNTIF($G5:$K5,$L5),L5,"")

Works great.
Thx guys for making me use my brains.


--
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