Conditional formating - Highlighting items in a separate column

[AFSSkier]

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)

"AFSSkier" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[AFSSkier]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>