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

Use conditional formatting with a formula of

=$C2="N"

--
HTH

Bob Phillips

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

"AFSSkier" wrote in message
...
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

This was very helpful. Thank you

"Bob Phillips" wrote:

Use conditional formatting with a formula of

=$C2="N"

--
HTH

Bob Phillips

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

"AFSSkier" wrote in message
...
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