rich

Morning All i had a table where i use row banding, quite simple odd rows white, even rows grey. the table got more complex when some rows had multiple lines that needed to be banded together what im wanting to do is alter the banding depending on a cell value, i found...

I use the formula to default to 70 if A11*B11 is less than 70. How do I change this so it doesn't default to 70 if the calculation is 0? Rich

<tbody> Col A Desired Result Mark 1 Mark 1 Rich 2 John 3 Rich 2 John 3 </tbody> Is it possible to create a formula that gives an incremental numerical value for duplicate values? My actual spread sheet will be bigger than the example above.

I have a workbook, Book-A, that I have defined a UDF. When I open a second workbook, it breaks the UDF on the first workbook. How do I stop this? Rich

Hi, my excel dose not have rich text box...how can i add it? thanks...

Hi, I've searched quite extensively for the answer to this question but can't seem to find a solution, hopefully somebody can help me out. I'm trying to fill in a form on a web page, but the form contains a text box that uses rich text. I can't find a way of filling in the text box. The rich...