|
do you mean is the Sum of d1:d100 = XX123 then XX123 becomes bold red?
If this is the case, select XX123, format -> conditional format.
if cell value = sum(d1:d100) font bold colour red.
Job done.
Pay me later.
__________________
╔═════════════════════════════════════════╗
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
╚═════════════════════════════════════════╝
|