Presever formatting on Data sheet in Pivot table

R

RMF

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
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top