Daniel_

Right - in this case you go to cell D2 (assuming tis is the first a/c no) and do cond.format. with the option being "cell value equals" XX123 (or whatever) and then make it red.

For a really special trick, create a cell at the top od the sheet (let's assume you use B1).

In the conditional formatting, say "cell value equals" and then "=$b$1". That way, cells will go bold and red if they match whatever you put into B1.

__________________

╔═════════════════════════════════════════╗
Overhead, the Albatross hangs motionless upon the air,
And deep beneath the rolling waves,
In labyrinths of Coral Caves,
The Echo of a distant time
Comes willowing across the sand;
And everthing is Green and Submarine
╚═════════════════════════════════════════╝