$$Excel-Macros$$ Re: Conditional Formatting by Group

2014-02-04 Thread itware2008
Hi JCraig, First of all, sorry for late response. My approach relies on creation of a helper column. In that column you should write this formula =g2&h2 and copy it down. Next select your data and click on conditional formatting. Manage rules. Use a formula to determine which cells to format.

$$Excel-Macros$$ Re: VBA Excel : comment filtrer des données différentes via deux command buttons sans les annuler?

2014-01-17 Thread itware2008
Bonjour, Vous pouvez envoyer un exemple de ce que vous voulez, et le code VBA que vous utilisez? Merci, Vândalo Domingo, 5 de Janeiro de 2014 17:57:50 UTC, marie.l...@gmail.com escreveu: > > Bonjour > > Je souhaiterais sur un même tableau filtrer à partir de deux > commandbuttons des données

Re: $$Excel-Macros$$ Re: Complicated Formula (automatic add back)

2013-11-07 Thread itware2008
Hello Amar, Perhaps this is what you want. Otherwise, please explain your goal with more detail. Best regards, Terça-feira, 8 de Outubro de 2013 13:18:32 UTC+1, amar takale escreveu: > > Dear Ravinderji, > > Thanks very much for great guidance for UDF VBA coding,I change little bit > in excel

$$Excel-Macros$$ Re: total Fridays in a range

2013-11-07 Thread itware2008
Please take a look at the enclosed file. You are able to select from the drop-down box the weekday you are looking for, below you find the number of occurrences for the weekday you had chosen. Cheers. Terça-feira, 1 de Outubro de 2013 15:18:15 UTC+1, asd...@gmail.com escreveu: > > vba returns

$$Excel-Macros$$ Re: Convert number of days to month and day (ie, 035 = 2/4)

2013-08-08 Thread itware2008
Hello Don, If I understood you, this function should help you =DATE(YEAR(TODAY());1;0)+A2 where A2 represents the number red by barcode scanner OS Quarta-feira, 7 de Agosto de 2013 23:41:24 UTC+1, Don Barton escreveu: > > Greetings, > I work at a hospital laboratory and we have an expiration