conditional format on a different column

[broman5000]

I know this is probably simple, but I must be missing something

What is the formula code on conditional formatting for this

Where Test (column N) = 1, make column column M background blue

Current Drop Week Unique Identifier	Test
LIVEM37232401	0
LIVER40232401	0
LIVEM35232402	0
LIVER32232402	1
LIVET24232501	1

[offthelip]

I am using EXCEL 2007 but it is much the same in more recent versions just that MS keep moving the menus around:

Select cell M1
Select conditional formatting “New Rule”
Then “Use a cell to determine which formula to format”
Then click in the box where it says: “format values where this formula is true”
Then click on cell N1, then type “=1”
Now select the Format button and select the colour you would like, then click ok
Now copy the formatting from M1 down the whole M column