|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com