tracking changes
Posted by Mark Gravelle on November 19, 2001 12:37 PM
I have created a macro that, when run, will search the assigned columns for any dollar amounts over $0.01 and highlight that cell yellow. But I currently have to execute the macro after all data entry is complete to get my final result.
Is there a formula I can place directly in the worksheet or in VBA that can continuously monitor these columns and highlight immediately when a value greater than $0.01 is entered? I tried the "track changes" but that just puts a blue arrow in the top corner of the cell? Thanks, in advance.
Posted by Mark W. on November 19, 2001 12:41 PM
Use Data | Validation... (nt)
Posted by Aladin Akyurek on November 19, 2001 1:17 PM
I guess...
you meant conditional formatting?
========
Posted by Mark W. on November 19, 2001 1:24 PM
No. I didn't, but...
...maybe I read too much into the inquiry. I
presumed that Mark wanted to regulate data
entry, but settled for "highlighting". Your
quite right if "highlighting" is all he wants
Conditional Formatting will suffice.
Posted by Aladin Akyurek on November 19, 2001 1:43 PM
Off topic..
Be warned. I'm going to spread your well-worded reply to Natalie Danquah about designing a spreadsheet under my second year students with your full name underneath.
Aladin
Posted by Mark W. on November 19, 2001 1:55 PM
Refresh my memory... what "pearl of wisdom" was this? : )
Posted by Mark W. on November 19, 2001 1:59 PM
Ahh! That wasn't me... someone usurped my moniker less the "." (nt)
Posted by Mark W. on November 19, 2001 2:01 PM
...Good advice though! (nt)
Posted by Mark G. on November 20, 2001 9:42 AM
Thanks, Mark & Aladin.....it worked great.
