Printable View
I have to make a project that I need help with.
I have plenty of tables (as shown on the picture) and I need to come up with a "Status Cell" (red in the picture). Trending status is what I am looking for: If current month value > Upper Limit then the Status Cell should be red. Otherwise - green. Trending of 2 consecutive month of growing - the cell becomes Yellow. Any ideas?
Is this an Excel question, or are you working with an unbound datagrid?
it is excel, i was wondering if i should do macro or an actual vb app for it
i guess its really hard if no one knows what to do :(
Well, you are certainly in the wrong section, since this is .NET, and Excel macros use VBA (which is related to Classic VB). Therefore, this should be moved.
However, even there I would expect that people would need a bit more explanation. In the image that you posted, there are a series of months, yet the values are all either 1 or 0, which makes it look like there really isn't enough of a range to account for either your trend (Yellow), or exceeding a maximum (Red). Is the maximum the UL? It appears to be a constant, as does the LL, in which case it hardly needs to exist in every column. It can be located in just one cell, thereby making formulas a bit easier....perhaps.
A better explanation of the problem is certainly going to be necessary.
Shaggy Hiker,
The maximum is the UL and it is in every column just because this data is used for a graph. I am attaching another example where numbers are different.
As a trend goes: if it raises within the UL for 2 consecutive months. For example Aug-10 to Oct-10 is a constant growth for 2 consecutive months within the Upper Limit. This one I want to define as a trend.
As far as .NET or VBA i was not sure what would be better to do and thats why I posted it here.
Im sorry for bad explanations, I am not a native English speaker!
Thank you
If you are doing this in Excel, then VBA would be the way to go. Technically, you could use .NET to create something like an Excel macro, but you will work harder to get the same thing accomplished. It seems to me that you are probably going to be better off creating an Excel macro, possibly tied to a workbook template.
ok, thanks for an advice! will the moderator move it to VBA section? I still need help on this one...
Thread moved to the 'Office Development/VBA' forum
(thanks for letting us know folks :thumb: )