software

Dear users,

I have a sheet with data which i need to update during the day. I need to
put cells that have changed compared to earlier that day in bold. Afterwards
I make a pivot table, but I need the pivot table to also show the values that
I have put in bold in the data sheet. I would like to avoid having to
highlight the changes manually in the pivot table so any suggestions on how
to do this easily are highly appreciated.

thnks,

RMF

The pivot table can't display cell formatting from the source list.
Perhaps you could mark another column, to indicate which records have
been changed. Then, add that marker field to the pivot table.

RMF wrote:
gt; Dear users,
gt;
gt; I have a sheet with data which i need to update during the day. I need to
gt; put cells that have changed compared to earlier that day in bold. Afterwards
gt; I make a pivot table, but I need the pivot table to also show the values that
gt; I have put in bold in the data sheet. I would like to avoid having to
gt; highlight the changes manually in the pivot table so any suggestions on how
gt; to do this easily are highly appreciated.
gt;
gt; thnks,
gt;
gt; RMF--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html