Hui,
Thanks a lot for your explenations.
I am too dumb to understand all this.
Is it possible that i send my excell sheet and you do this job for me and send it back? then i can see how have you done it and then try my luck?
Let me know how can i send the sheet to you.
Thanx Narayan,
But i am not too good in VB. I remeber one of my friend use to do it with some formula in excell. Please let me know if you have easy solution for it.
Hi,
I am making my work schedule sheet for evey month.
Like if i am working from 1st to 15, then i mark those cells as red, and if i am off from 16 to 30th, then i mark them green. Now what formula should i use to calculate number of red cells and number of green cells. And i want to display...