Trying to be able to draw attention to any cells that have been manually edited.
Presuming the cell contained a formula, is there any way to highlight a cell that does not contain a formula?
thinking maybe if("<>"the original formula)?
Sounds painfully redundant from an efficiency standpoint.
Is there any built in rule for if a cell does not contain a formula?
alternatively I may just lock the whole darn sheet.
Hi
If you think that will work for you, then we can do the Opposite of what you ask for!
I mean that we can,using Conditional Formatting, to highlight all cells that contain formulae. So the "white" cells don't contain formula...
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Here is a link to instructions on how to highlight cells containing formulas and can adapt for the opposite.
http://www.j-walk.com/ss/excel/usertips/tip045.htm
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks