hi all

im new to all this, what i need to do is write a macro to change the value on a spredsheet to add a value of 1 in a green cell and X in any other colour and save the results in a csv text file to open in note pad, im almost there ive found how to change a value in a coulor cell by selecting a cell but not for everyother colour

any help would be much appriciated

thanks

chris