The formulae are like this:

=AND(Z6=8,(COUNTIF(A6:CC6,8)+COUNTIF(Z2,8)+COUNTIF(Z4,8)+COUNTIF(Z8,8)+COUNTIF(Z10,8)+COUNTIF(Z12,8)+COUNTIF(Z14,8)+COUNTIF(Z16,8)+COUNTIF(Z18,8)+COUNTIF(H2,8)+COUNTIF(H4,8)+COUNTIF(Q2,8)+COUNTIF(Q4,8))=1)

That is, if the value of Z6 is '8', and it is the only 8 in row6 from cols A to CC, and the only 8 in (1) rows 2, 4, 8, 10, 12, 14, 16 and 18 of col Z, (2) rows 2 and 4 of col H, and (3) rows 2 and 4 of col Q, then format Z6.

Using the right arrow to move along the formula, even with Ctrl or Alt, doesn't work. It simply puts in unwanted cell references wherever the cursor line happens to be.

Expanding the window by clicking the symbol at the right does not give me the entire formula in two windows.

Is there some way of moving the cursor line along the formula, character by character, so that every element of the formula can be checked/edited within the formula window?

markly