[excel formulas]

thanks a lot! that has helped me immensly, and i have now completed the sheet and it all works accordingly, thanks again....

[excel formulas]

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

[excel formulas]

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

[Using a macro to go between programs?]

ok thanks very much, extremly helpful and has done the job.

thanks again,

chris

[Using a macro to go between programs?]

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

[Using a macro to go between programs?]

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