Conditional Formatting Query

Hi,

How can I have one conditional format that changes the colour of Column M to red, if any of the following:

880
886
918
937
500
527
571
587
590
595
966
975

Appear in Column L.

Many Thanks

Try listing those values somewhere on your sheet and naming that list, e.g. numberlist...then select column M and use this formula in conditional formatting

=MATCH(L1,numberlist,0)

format as required

That will format M5 if L5 contains one of those numbers, etc...... If you don't want a list you can use a formula like this

=OR(L1=880,L1=886,......L1=975)

fill in the gaps .....

Put you list somwhere (i.e. U1:U11) and then use in CF:

=COUNTIF($U$1:$U$12, M1)>0