Search results for query: *

thx for that. is there a way of running this automatically when a cell is populated with a number?

Judt trying to use the above codes to allow me display different colour cells when the values are in specific ranges. i.e. < 5, between 5 and 10, > 10 can anyone help? cheers

do you know if there is any other way around this, without adding a macro? thx

Hi, Does anyone know if it's possible to add more than 3 contraints to the conditional formatting function in Excel? Cheers

lovely,,, cheers guys!!

Hi Guys, Me again! I'm trying to use the countif function, but with two contraints. Those being: If a cell in column a = &quot;test&quot; and count the number of cells containing &quot;test2&quot; in column b. I've tried to work around this, but can't get it to work,, any ideas? Cheers

magic!! cheers guys!!

Actually delete all cells with &quot;Hello&quot;, in say column A, after that move the other cells to the left. cheers

Hi, Does anyone know the VB to delete all cells which have a certain criteria (eg &quot;Hello&quot;) to the left? Cheers

Hi, Is there a way of using the OutputTo macro option, to save as an Excel 2000 format, instead of 95 format, with Access 2000? Thanks!

Hi, Is there a way of using the OutputTo macro option, to save as an Excel 2000 format, instead of 95 format, with Access 2000? Thanks!

thanks!! worked a treat!! :)

Hi, Is there a way to set some specific date ranges, which will apply to numerous queries in one go? For example I have lots of queries where the date range should be from the start of the month to the end. Is there a way of entering this once, which would apply this to the selected queries...