Hi Guys,

I want to Conditional Format A whole spreadsheet by 3 rules.

If cell Ax reads 1 then fill that cell Red
If cell Ax reads 2 then fill that cell Green
If cell Ax reads 3 then fill that cell yellow.

Its not working though.

Please see an Image from what I attempted after a bit of research;

Format.jpg

Hopefully behind the dialogue box you can see that I have 2's that are red etc.

Any Ideas?