Search results

that worked Deb, thanks. I wonder if your able to receive the uploaded sheet I sent?

https://rapidshare.com/files/3950702252/conditional format vb.xls I had to become member there and uploaded the file I hope this is correct

everything in my sheet works but not the vb code. I have formulas in that range which give results (0,1,2,3,4,5,6.)end. i need vb to give conditional format colour, to cells, depending on which of the seven numbers comes up as a result of the formula. example: if 6 the colour red, if 5...

My column L has all formulas in it and the formulas give answers 0-6 maybe thats why not working? regards henk

Im not having any luck. I copied and pasted as you text it to me but nothing works. I'm not experienced vb user. I don't know what I'm doing wrong regards henk

Sorry but that still not working.my sheet is called "enter results" and my actual column is L3:L1000 can you send the right vb with these details? regards henk

Hi Mercatog I entered the vb code but nothing happens, not working? any idea/ regards henk

I have a new question re conditional format. On the toolbar in excel 2003 there are only 3 conditional formats possible, I need 7 conditional formats. a1:a100 can be amounts 0,1,2,3,4,5,6 as the formulas in the aray will give these amounts. I need to enter into vb the code to give me 7...

Hi everyone that tried to help me on this one. MERCATOG 1st formula =SUMPRODUCT(COUNTIF($A$1:$A$10,$B$1:$B$10))is simple and works like a charm. Thank you very very much everyone. What a great site to get help, my first time.

Thanks Kyle but I need to count how many numbers are the same in a single cell. in my example the answer is 3. Hope you or someone can help?

a b 1 11 17 2 12 10 3 13 8 4 14 3 5 15 11 6 16 12 7 17 6 answer = 3, as both columns have 3 numbers the same 11,12,17 What is the formula someone please?

a b 1 11 17 2 12 10 3 13 8 4 14 3 5 15 11 6 16 12 7 17 6 answer = 3, as both columns have 3 numbers the same 11,12,17 What is the formula someone please?