Conditional formating - Highlighting items in a separate column

[Guest]

Using Conditional Formating, I would like to hightlight the inactive item SKU
numbers in column A from the condition of column C = "N". For example,
SKU#'s 733964 & 733733 below would be highlighted.

SKU# DESCRIPTION ACTIVE
733667 WIDGET 123 Y
733964 WIDGET 124 N
733956 WIDGET 125 Y
733717 WIDGET 126 Y
733733 WIDGET 127 N

 

[Bob Phillips]

Use conditional formatting with a formula of

=$C2="N"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

This was very helpful. Thank you

Use conditional formatting with a formula of

=$C2="N"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)