-
thanks a lot! that has helped me immensly, and i have now completed the sheet and it all works accordingly, thanks again....
-
i would like a cell to say IF(c1=c2,"CELL COLOUR IS RED","CELL COLOUR IS BLUE") But how do i write this properly so the cell colours actually change. i cannot use conditional formatting, because on the shared workbook i am using it is not accessible. thanks
-
instead of using conditional formatting in excel to change the colour of a cell, is there a formula where the cell can = the colour red. thanks for your help. chris
-
ok thanks very much, extremly helpful and has done the job. thanks again, chris
-
sorry this doesn't seem to work, i type it in the visual basic editor and it still doesn't work, can you give me the whole code again but with an example within it please. thanks for your help
-
hi i'm using excel '97 and i want to create a macro so that it will open ms project and open the file, then go back to excel. but when recording the macro in excel, it doesn't record the fact that i have opened project, so it doesn't work. how can i get it to record the program change? thanks