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.
=$P1=INDEX($T$1:$T$1000,MATCH(TRUE,$T$1:$T$1000<>"",0))You can try this rule for conditional formatting. Maybe this is what you are looking for. The "applies to" range in my sheet is:
=$P:$P
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.
=NOT(ISNA(VLOOKUP($P1,$T$1:$T$1000,1,FALSE)))You can try this rule for conditional formatting.
In your initial question and example it seems that you only want to highlight the value of the first non-empty cell of column T. Only this value is highlighted in column P in your example.
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.
