conditional format - coluration

Hi John,

In your case both

=(T3=1)*(N3="r")   or
=($T3=1)*($N3="r")

works if you apply it not to entire column T but to range $T$3:$T:$nn. Use absolute or relative references depends on to which range you apply the rule. Conditional formatting takes the rule as it is and apply to the first cell of the range, for each next cell the rule is modified same way as you copy the formula from cell to cell. For T4 it will be checked if (T4=1)*(N3="r") returns TRUE, etc.

If your rule is =($T$3=1)*($N$3="r") it colour all cells in the range depends on what you have in T3 and N3, doesn't matter what in other cells.

Similar if you'd like to colour entire rows, not only cells in column. When absolute references in the rule for column ($T, $N), relative for rows and rule is applied to range like $A$3:$Z$nn.

As for the second question if you attach small sample it'll be much more chances someone answers. To answer people most probably shall generate small model and play with it -your sample will help.