PDA

View Full Version : Differentiate between sources of results on cells



Sylvia2012
02-07-2012, 05:59 AM
Hey all,

I need some ideas on this topic:

Excel workbook with multiple spreadsheets, each spreadsheet has some numbers. Those numbers are either hardcoded, or they are result of in-sheet formula, or they are a result of a fromula coming from another spreadsheet or they are loaded from external data source (FAME Populator).

I need ideas to distinguish between those cases so the result will be a cell colored differently according to which of the abovementioned cases the number belongs.

Cheers,
S.

mdmackillop
02-07-2012, 06:28 AM
You can use SpecialCells to identify formulae and Constants. Does your Fame data appear as Constants. How are these loaded?

Sylvia2012
02-07-2012, 06:42 AM
Dear mdmackillop,

Yes, thank you SpecialCells is one option but how does one distinguish between formulae coming from the same workshet or from another one.
What do you mean how are the Fame data loaded?

mdmackillop
02-08-2012, 02:16 PM
I've no idea how you mean to implement this or what your present data, in particular Fame data looks like. Has it any distinguishing "marks". Is it there as the result of running code or what?