I will try to be as clear and concise as possiable and adhear to the forum rules. I'm not a excel wizz, though I know the bascics and am willing to learn, if i dont use the right terminology to describe my problem please forgive me.
Here's what i am trying to do:
I have a list in column A, in thise list there are repeated words eg the word sugar is repeated in A23, A45, A56 etc.
In column B i have condition format so when i type a 'x' it turns the cell color from red to green.
What i am trying to do is if i enter the 'x' in column B in relation to the word - in this case sugar - it will automatically enter a x in all the other cells in B that has the word in there corresponding A column that matches the orginal 'x'
So for example if the word sugar is repeated in A23, A45 and A56 regaredless of where i enter the 'x' in the b column, weather its B23, B45 or B56 then cells i didnt manually enter the x will auto update in corresondance to the word...
I hope i have been clear and someone can help.