Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling out data based on font colour
I have a large table of data, containing several rows and columns. Some of the data is "assumed", and to indicate this it appears in a red font colour. All "real" data is of black font colour. On a separate worksheet, I want to "pull out" all the assumed data. e.g. below (in this example, "assumed" data is shown in square brackets): Age Height (cm) Weight (kg) Jane 21 [89] 70 Tom 37 [90] [60] Brian [45] 78 [72] Paul [25] [86] [80] So, on my second worksheet, it would display something along the lines of: Assumed data: Age Height (cm) Weight (kg) Jane 89 Tom 90 60 Brian 45 72 Paul 25 86 80 Is there any way of "pulling" data out in this way, i.e. based on font colour, perhaps using and IF statement? -- terryc ------------------------------------------------------------------------ terryc's Profile: http://www.excelforum.com/member.php...o&userid=35796 View this thread: http://www.excelforum.com/showthread...hreadid=557788 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling out data based on font colour
My home page contains a macro which sorts by colour - this might give you a way in. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=557788 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions |