Conditional Formatting from another sheet

[GreasedShepherd]

Hello,
I'm pretty new to using Excel to it's full potential.
Now I'm trying to get some conditional formatting done.
I want to use the data from Sheet 1 to colour some cells in Sheet 4.
I want to use the date Sheet 1, B3:B33, to Sheet 4, C4:AG10.
When there is a value (1,2,3) in Sheet 1, I want to have each a color.
I tried to transpose the data to sheet 4 but I cant get it to work.
Can anybody help me? I'm new to this.
Thank you in advance.

 

[6StringJazzer]

I want to use the date Sheet 1, B3:B33, to Sheet 4, C4:AG10.

Sorry, I'm not following what this means. On Sheet 1 you are referring to 1 column 31 rows. On sheet 4 you are referring to 31 columns 7 rows. They don't correspond.

Please describe exactly the logic you want to use to color a given cell in Sheet 4, and the colors you want. Also give a couple of concrete examples. For example:

For cell D7, if Sheet 1 B11 is 1 use green.

 

[GreasedShepherd]

Sorry, I'm not following what this means. On Sheet 1 you are referring to 1 column 31 rows. On sheet 4 you are referring to 31 columns 7 rows. They don't correspond.

Please describe exactly the logic you want to use to color a given cell in Sheet 4, and the colors you want. Also give a couple of concrete examples. For example:

For cell D7, if Sheet 1 B11 is 1 use green.

It is a bit complicated.
The info in the 31 rows on sheet 1 need to connect to the 31 columns on sheet 4. And that for a length of 7 rows.
This is the example I have for sheet 4. Now I did it manually but I want to automate it when I change it in sheet 1 the colours change.
So when there is a 1=Yellow 2=Green 3=Bleu