How to apply conditional formatting for multiple c

问题:

I have a list of names in column A I have a list of names in column B determined by formula.

I was the specific name to turn green in column A if it is present anywhere in column B.

e.g. A - 10 names, only 3 are "drivers" B - I type driver names and other names as I 'fill the cars' with people. I want the name in column A to turn green when I type it in column B so I know they've been sorted.

Working in google docs

回答1:

Click on cell A1. Then choose Conditional Formatting -> New Rule from the menu.

Choose the option "Use a formula to determine which cells to format".

Type the following formula into the box:

= (SUMPRODUCT((A1=B:B)+0))>0

Click the "Format..." button to set the color to green.

Click OK.

Under "Applies to", type in your range of cells in column A where you want the conditional formatting to apply.

See below example that shows this conditional formatting applied to cells A1 to A4. Notice how any name in column A that appears anywhere in column B is green.