| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If color in a then value in b
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If color in a then value in b
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If color in a then value in b
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If color in a then value in b
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If color in a then value in b
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If color in a then value in b
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(L210,L2,"") or something similar. -- HTH RP (remove nothere from the email address if mailing direct) "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert some data in the row to columns? | Excel Discussion (Misc queries) | |||
| counting text in a column | New Users to Excel | |||
| ISBN Check Digits | Excel Discussion (Misc queries) | |||
| Formula for Colin F | Excel Worksheet Functions | |||
| Custom format | Excel Discussion (Misc queries) | |||
Hybrid Mode
