Is there a condition format or formula I can use for the scenario below:

A B C D
1 MAD Y
2 LON Y
3 EDI N
4 MIL Y
5 KUL N

I need cell in column A to be in colour if cell B = Y. Exp above, Cell A1,
A2 and A4 should be in the colour I choose.

Thanks.

Conditional Formatting
Formula Is: =$B1="Y"

Format any color you like


"Kim" wrote:

> Is there a condition format or formula I can use for the scenario below:
>
> A B C D
> 1 MAD Y
> 2 LON Y
> 3 EDI N
> 4 MIL Y
> 5 KUL N
>
> I need cell in column A to be in colour if cell B = Y. Exp above, Cell A1,
> A2 and A4 should be in the colour I choose.
>
> Thanks.

It work. Thanks.

"Teethless mama" wrote:

> Conditional Formatting
> Formula Is: =$B1="Y"
>
> Format any color you like
>
>
> "Kim" wrote:
>
> > Is there a condition format or formula I can use for the scenario below:
> >
> > A B C D
> > 1 MAD Y
> > 2 LON Y
> > 3 EDI N
> > 4 MIL Y
> > 5 KUL N
> >
> > I need cell in column A to be in colour if cell B = Y. Exp above, Cell A1,
> > A2 and A4 should be in the colour I choose.
> >
> > Thanks.