Conditional formatting based on value in another column

[wace]

Hi,

I am trying to create a conditional formula to highlight cells with a 'W' in column M based on the name in column N (in the attached example I've used the name Bob).

So in other words, if there is a 'W' in column M and on the same row the name 'Bob' is in column N, then I would like the cell containing the 'W' to be filled.


I've tried a few times to make this happen but no luck so far.

Thanks in advance!

wace

[NBVC]

Select the M column range and go to Home|Conditional Formatting, select New Rule

Select Use formula to determine which cells to format

enter formula:

=AND(M4="W",N4="Bob")

click Format and choose from Fill tab

[wace]

Perfect!

Thanks,

wace