Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-01-2013, 03:25 AM
C J Squibb C J Squibb is offline Find out whether a cell has been typed or calculated Windows 7 64bit Find out whether a cell has been typed or calculated Office 2010 32bit
Novice
Find out whether a cell has been typed or calculated
 
Join Date: Aug 2013
Location: Essex
Posts: 14
C J Squibb is on a distinguished road
Question Find out whether a cell has been typed or calculated


I have a spreadsheet using VLOOKUP() to offer default values for certain cells. I would like to force this value to be typed manually, even if correct, so that if the lookup table value is later updated, previous entries remain unchanged. Is there a way I can identify the cells where the value has been derived from a formula, so that I can use conditional formatting to show these entries in grey?
Reply With Quote
 

Tags
conditional formatting, formulas, vlookup



Similar Threads
Thread Thread Starter Forum Replies Last Post
the character "v" when typed acts like ctrl-v. jim redfield Word 1 09-22-2012 05:19 AM
Find out whether a cell has been typed or calculated Can I set AutoCorrect to work with inserted text (not typed)? kyjac85 Word VBA 3 09-14-2012 08:19 PM
Find out whether a cell has been typed or calculated Inserting a date calculated from a table cell theMikeD Word 2 09-11-2012 05:46 PM
Find out whether a cell has been typed or calculated Text typed on slide x ports to slide y automatically? Thinker PowerPoint 5 07-26-2012 11:59 PM
Find out whether a cell has been typed or calculated Calculated dates. Ziggy-R Word 10 09-28-2010 01:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft