| 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 |
| 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) | |||
Threaded Mode
