Conditional formatting with an IF function

[Balmer07]

Hi,

I am currently working on a spreadsheet which I need to conditional format for the user.

In column 'B' I have either "inbound" or "outbound" and in column 'C' I have Product codes (E.g Part 1, Part 2, Part 3)

I am not sure if conditional formatting can do what I need and it may require VBA but hoping someone can advise me on here first before I start into VBA

Basically if column 'B' contains "outbound" I want to conditional format to bypass the formatting. However if Column 'B' contains "inbound" I want the Part code to be highlighted in Column 'C'.

I hope this makes sense.

So far if i use the below formula the product codes highlight for both inbound and outbound.

=OR(C1="Part 1",C1="Part 2",C1="Part 3")

Many thanks in advance!

 

[Balmer07]

Hi Marcelo,

I checked your method using 'AND', it also works as well as 'IF'.

Thanks for your input however

Steven