LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Kevin
 
Posts: n/a
Default How to identify a cell without a formula

I have a worksheet set with = reference to a cell in another worksheet.
Conditional formatting is set to color the cell if the value is greater than
0.
Is there a way to add to the conditional formating to the same cell that
will color the cell a different color if the value is input and not from the
formula?

My goal is to identify cells that have had their formula overwritten with
manual input. There are times a manual input needs to be entered and I need
to visually see which cells are not based on a formula. I don't want to set
protection on.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM
Can a Formula in Cell X modify Cell Y? alMandragor Excel Discussion (Misc queries) 7 February 10th 05 09:51 PM
looking for a formula Amanda Excel Worksheet Functions 5 January 5th 05 07:37 AM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"