If color in a then value in b

  • Thread starter Thread starter Desert Piranha
  • Start date Start date
D

Desert Piranha

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,"")
 
Hi!

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

Biff

"Desert Piranha"
 
Biff said:
Hi!

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

Biff

"Desert Piranha"
message
Click to expand...
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.
 
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"
 
What Biff is saying is that say you have a CF test that says if a cell value
is greater than 10, turn it red. In M, just add the formula

=IF(L2>10,L2,"")

or something similar.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Desert Piranha"
 
Biff said:
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"
messag
Click to expand...
Ok, got 3 hours sleep and reading your & Bobs posts the light finall
went on.
The numbers in Col L have Conditional Formating turning them Blue Bol
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 Co
L.

BUT the color really has nothing to do with it. So i used an IF formul
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
 
Back
Top