formatting cells base on value of other cells

[sanlen]

Hi,

I am trying to use conditional formatting to formate the cell base on the values of other cells.

I have attached the link to show the sample of the formatting that i am trying to show on my sheet.

http://www.box.net/shared/e08o6su5i3


Your comments will be very much appreciated and sorry for any inconvenience.

Thanks,
sanlen

 

[JamesW]

It should change to red, make sure the order you have setup your conditions is as I put above: RED needs to be first.

As I said, you will have to change the range from J5:M5 to J6:M6 if the values are there.

I have tested it exactly as you said and it turns red (MS01 is a date and MS02 is "Issue").