formatting with colours and multiple sheets

Hi all. I’m wondering if anyone could help me with some formatting that I’m trying to achieve?:

1. I want to change the colour of any cell within a column to a specific colour (one of four or five set colours) based on the text of that cell. For example; if I type R1, R5 or R12 I want the cell to change red. If I type between Y1-Y12 I want the cell to turn yellow. This would mean there would be 48/60 different potential codes and 4/5 different potential colours per cell.
2. I have a red, yellow, blu and green section on separate sheets each with 12 cells that will have information in. I want the text of each cell on the colour sheet to reference whichever cell is one to the right of the cell that I typed the code on the main page. For example; If I type B1 on the main page and the cell to the right of it says “piano” I want the cell in the blue section to read “piano"

If this could be done in a way that is cross compatible on excel that would be great!!

Hi,

I have tried to post link but it says I'm not allowed to do that because I haven't posted enough. Also the upload feature doesn't work for me...