Fill cells depending on colour?

[Mattneedshelp]

I have a worksheet that im using with other team members as sort of a checksheet on a batch schedule. We're using a colour coding system where red means the job hasnt been built, green means it has been built and yellow means it's ready to be built.

I also have another column where we put a 'Y' when the job has been built. I don't know if this is possible, but what would be ideal is if somebody put a 'Y' in column F, then columns A,B and C would have their cells fill coloured green. If an N is put in, then the cell fill would be red.

Is this possible through excel? Would it require VBA?

[Fotis1991]

Hi

You can do it, using Conditional Formatting.
Highlight your range(Let's say A1:C1000)

In Conditional format rules, formula is.

First rule=$F1="y" >>>Choose your Green color>>OK.

Second rule =$F1="N" >>>Choose your Red color>>OK.