I need help for Conditional Formatting.

[akinkaraman]

I want to make the color of Zones changes according the colors of Zone below.

Thank you.

[akinkaraman]

I found the answer =>

Click the range of cells you want
Click new Rule/Cells that Contain
Under Format Only Cells With: select Specific Text/Containing/ enter A
Format Fill Red/OK/OK/Apply (you could click OK, but Apply leaves you in teh window to repeat)

Repeat the above for each letter, with its color