Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change Font colour mid-worksheet: Excel 2003
I have a large worksheet (6,000+ rows) that I am continuously updating
I need to quickly and easily see all "recent" changes made as I scroll through At present, the data in each worksheet cell are all in black (+ Times Roman) fonts - I would like all changes and additions to be very apparent - in say red - and this should ideally include changing data within a cell - say changing "Note" to "Notes" with just the "s" showing up red Then when I am happy with certain changes, I want to Format Paint them to black as I scroll through - leaving only the queries and any new-new additions, etc. continuing to show up in red - or even make newer changes in a different colour again? I've tried Track Change markups, but they are difficult to see and a bit fiddly to read what correction I made in those little "PostIt" boxes.... Any ideas? Thanks |
#2
|
|||
|
|||
Hi john,
I had an idea untill you hit the "new-new additions" and the "newer changes" part. you may have to define what you mean by the phrases. and you may have to define what you mean by "recent changes". remember - computers are stupid. you have to tell them everything and they only see in black and white. It is either a recent change or it's not. "John L" wrote: I have a large worksheet (6,000+ rows) that I am continuously updating I need to quickly and easily see all "recent" changes made as I scroll through At present, the data in each worksheet cell are all in black (+ Times Roman) fonts - I would like all changes and additions to be very apparent - in say red - and this should ideally include changing data within a cell - say changing "Note" to "Notes" with just the "s" showing up red Then when I am happy with certain changes, I want to Format Paint them to black as I scroll through - leaving only the queries and any new-new additions, etc. continuing to show up in red - or even make newer changes in a different colour again? I've tried Track Change markups, but they are difficult to see and a bit fiddly to read what correction I made in those little "PostIt" boxes.... Any ideas? Thanks |
#3
|
|||
|
|||
Looking for utopia in a logical world??!
What I was after was say setting every new (July) input into the existing database in a red font, then on 1st Agust change the settings so that all entries, corrections (i.e. every keystroke) appear in green. That way I can routinely view the database and accept all the red/green data that I am confident with/have checked by Format Painting it black. Then, if there is a query/data that I need to check, I can see it in red and go to my "July" data source or green for August, etc. However, if the database showed only red for everything that I input from now on, I can live with that! Any thoughts most appreciated! John L "FSt1" wrote: Hi john, I had an idea untill you hit the "new-new additions" and the "newer changes" part. you may have to define what you mean by the phrases. and you may have to define what you mean by "recent changes". remember - computers are stupid. you have to tell them everything and they only see in black and white. It is either a recent change or it's not. "John L" wrote: I have a large worksheet (6,000+ rows) that I am continuously updating I need to quickly and easily see all "recent" changes made as I scroll through At present, the data in each worksheet cell are all in black (+ Times Roman) fonts - I would like all changes and additions to be very apparent - in say red - and this should ideally include changing data within a cell - say changing "Note" to "Notes" with just the "s" showing up red Then when I am happy with certain changes, I want to Format Paint them to black as I scroll through - leaving only the queries and any new-new additions, etc. continuing to show up in red - or even make newer changes in a different colour again? I've tried Track Change markups, but they are difficult to see and a bit fiddly to read what correction I made in those little "PostIt" boxes.... Any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
exporting excel worksheet to word | Links and Linking in Excel | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
How do I get traffic lights in excel that change colour | Excel Worksheet Functions |