Have two copies on the matrix on the same worksheet.
Let's say one begins in A1 and the other in AA1
You will be updating the first matrix
Select all the first matrix; use Format | Conditional Formatting; set
Formula Is to =A1<AA1 (do NOT use =$A$1<$AA$1) and set the font to blue
Now when you change something in the first matrix it will display in blue.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"jaygreg" wrote in message
...
Using Excel 2003. Made copy of a matrix I built years ago. Now want to
update it and show which cells have changed by making the font blue rather
than black. Too many changes to make by just changing the color after each
adjustment. Can't find anything that will permit me to change the font
color and make it the default while I finish the update. Can someone point
me in the right direction please?