LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Conditional Formating based on method of input

I am looking for assistance with having a cell change color if the cell data was put in/changed manually rather than through a formula. For instance, I have a cost spreadsheet that is using a reference file to to input data in the cells, however the reference sheet cost data may be based on 10,000 pieces and I know that there is a price break if I order 20,000 piece so I change the cost in the cell to reflect the different cost. I then want that cell to change color b/c the data did not come from the reference file/formula and was put in manually.
 
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
conditional formating for the whole row, based on one cell value Renata Excel Discussion (Misc queries) 2 January 7th 10 12:16 AM
Conditional Formating based on Date Flcnmech Excel Worksheet Functions 1 February 14th 08 08:21 PM
Conditional Formating based on a different cell Zsolt Szabó Excel Discussion (Misc queries) 2 December 9th 06 09:18 PM
Conditional Formating Based on Date Roy Excel Discussion (Misc queries) 5 June 7th 06 04:49 PM
Conditional formating based on text mango7 Excel Worksheet Functions 6 February 8th 06 10:11 PM


All times are GMT +1. The time now is 03:47 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"