COLOR OF CELL OF A COL WHEN CHANGED THEN CELL COLOR OF B ALSO CHANGED

[AFZAL SOHAIL]

Hello Respected Team:-
I have a question that if I change the color of Cell in col-A then color of adjacent col-b cell should changed is as under:-
I need a formula.

FZRD: OLT-1 to C-10 Main Chungi Amrsadhu	TNSP
SMD: B-36 Opp. Shadman Market to B-1 Bagh Gul Begum	SMD
SMD: B-25 Cricket House to C-5 Services Hospital	SMD
8057-FZRD (11/0/3) to 7301-Ufone (2/0/2)	TNSP
MLRD: OLT-1 to C-41 Sabzazar	SMD
MAL: MSAG-13 Sundar Industrial Estate to MSAG-15 Sundar Industrial Estate	JTN
8062-WTN to 7038-Ufone	TNSP
GTN: C-2 P-Block GLB-III to C-2A Main Enterance GOR-VI Opp. Arfa Karim Tower	GTN
JTN --- BTN	JTN
FZRD --- TNSP	TNSP
GTN: OLT-2 to 94-S Block Model Town	GTN

 

[AFZAL SOHAIL]

Thanks a lot Sir,
If i want with conditional formatting, then what will be the procedure?

 

[Peter_SSs]

Conditional formatting cannot detect when another cell is manually coloured.

 

[Peter_SSs]

I have removed the 'Mark as solution' from post #10 as it does not answer the original thread question. If another post does then you can mark that otherwise please don't mark any as this will better help future readers.

 

[AFZAL SOHAIL]

OK thanks Sir,