Forum Discussion
Conditional formatting
Select the range you want to format, for example P1:P100. The first cell in the selection should be the active cell in the selection - in this example P1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ISNUMBER(MATCH(P1, $T$10:$T$13, 0))
If you have more cells in column T that you want to use, expand the range $T$10:$T$13.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
is it possible to highlight all the cells in column P respective to column T. it seems like your formula only highlights the first instance it encounters.
Select the range you want to format, for example P1:P100. The first cell in the selection should be the active cell in the selection - in this example P1.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=ISNUMBER(MATCH(P1, $T$10:$T$13, 0))
If you have more cells in column T that you want to use, expand the range $T$10:$T$13.
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.