Conditional Formatting to show if a formula has been changed
Hi,
I need to conditional format a range of cells containing a formula to show if they have been overwritten or changed.
I would like them to highlight the cell orange.
I need to do this in instances both where the formula remains constant, and also where it may change due to the cell changing, i.e when a formula is dragged down.
If anyone knows how to do this it would be massively appreciated.
Thanks
I dunno how to do that without getting into VBA, rather than conditional formatting / functions.
Does the built in Track Changes functionality not fit your needs?
Hi - No the track changes is no good in this situation as I would like the sheet to be used by multiple users and really want something that flashes up if visually if something is changed.
Any other bright ideas?
In that case the simpliest solution I've found is from a thread on Mr.Excel from June 2001 where Aladin Akyurek described probably the simpliest non-"Hello World" UDF (user defined fuction) I've ever seen:
That returns a boolean, much like ISNUMBER or ISTEXT.
Please Login or Register to view this content.
Anyway you conditional format cell A1 with whatever font you want using the function rule
=ISFORMULA(A1)
Then you apply it to whatever range of cells you want to check.
Hope that helps.
EDIT:
If I'm misunderstanding and you just want to reproduce the functionality of track changes with conditional formatting instead of distinguising formulas from inputs, then check out this thread on superuser.
Last edited by ben_hensel; 11-12-2013 at 11:23 AM.
Thanks very much for your help Ben. I will try this out on Friday (very busy week!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks