This is a soccer database where i would like it to notify
me if weather "d(raw)" weather "l(oose)" weather "w(in)"
doesnt occur in one of the at least 6 last matches.
its all explained in the excel file in att
ty in advance
best regards
alain de pauw
Last edited by thealian; 11-24-2012 at 03:42 PM.
No VBA really needed, I don't think. You can just add more tracking columns to the right and evaluate the data as you add to it.
Like so...(attached)
Now, you can apply some conditional formatting to those new columns to hide the colors/fonts (make the cell go all white) if the value in the cell is less than 6.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Re: if one of the 3 strings is missing sinde the last 6 matches then i want notification
SOLVED
Mate your a genius to me, if i can win some money with this little app
i asure you that you'll get a part of it
of course i studied the whole case, and i understand it, dont believe it myself
ty soo much
alain de Pauw
ps sorry looking for an option to say it solved, cant find it even in advanced
Last edited by thealian; 11-24-2012 at 03:41 PM.
found hope it says solved, had to edit original message hoohohohoh dear me
ty again
alain
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks