i need help with a problem
i want to be able to see when values have been updated in a spreadsheet.
My thoughts are pointing towards the font changing colour when a value has been increased and a seperate colour when the value has decreased.
I am using Excel 2003
Thanks in advance
Mickky
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free fromhttp://
www.shemes.com/ =-
You could copy the values in those cells then paste them into an "out
of the way" part of the sheet (the range of cells with the pasted
values could later be hidden) then use Conditional formatting to show
up any changes.
As an example, say the range to be kept track of is A2:B21 and columns
AA and AB are free to be used. You could copy A2:B21 then select AA2
and Paste Special, Values.
Now, if you want the indication of change to appear in A2:B21 then
select A2:B21 and go Format|Conditional formatting...
This brings up the Conditional formatting dialog.
For Condition 1 choose "Formula Is" from the left dropdown then into
the textbox to the right type...
=A2<AA2
then click the "Format..." button to bring up the Format Cells dialog
where you can choose an appropriate font color (I personally prefer to
change the cell background which is done on the "Patterns" tab sheet)
to indicate that the cells value has decreased. Click OK to return to
the Conditional formatting dialog, then click the "Add >>" button to
add a 2nd condition.
For Condition 2 choose "Formula Is" from the the left dropdown then
into the textbox to the right type...
=A2>AA2
then click the "Format..." button to bring up the Format Cells dialog
where you can choose an appropriate font color to indicate that the
cells value has increased. Click OK to return to the Conditional
formatting dialog, then click the OK button to finish.
If you want the indication of change to appear on the cells with the
original pasted values then select AA2:AB21 then apply exactly the
same conditional formatting.
Ken Johnson
