Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull data in a new colour
H
I have a workbook containing worksheets "Feb" "Apr" "Jun" "Aug" "Oct" & "Aug". There is a merged sheet called "Consolidated". On the consolidated sheet, I have information regarding all clients contined on the other sheets which is pulled in from each sheet Some addresses are pulled from "Dec" and where there is no address in this sheet I work backwards until all addresses have been pulled in. I work backwards because "Dec" contains all the latest known addresses which may have been updated frim the other worksheets due to clients moving etc The formulas I use for each part of the address is as follows =IF(ISERROR(VLOOKUP($A2,'Dec'!$A$2:$E$447,5,FALSE) ),0,VLOOKUP($A2,'Dec'!$A$2:$E$447,5,FALSE) This works fine but now I have to have a way to know which record is pulling from which sheet. Is there a way to add something to this code to make the text or cell a particular colour. I would like to have data pulled from "Dec" in red and data pulled from "Oct" in blue etc. I hope this makes sense Thanks in advanc Malcolm Davidson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink into IE to pull data? | Excel Discussion (Misc queries) | |||
Pull data from various worksheet | Excel Worksheet Functions | |||
can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
pull data for a company with data in diff cells multiple wrkshts | Excel Worksheet Functions | |||
Pull multiple data | Excel Worksheet Functions |