Condition Format with value of other column
 

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.

Condition Format with value of other column
 

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.

Condition Format with value of other column
 

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.