I created spreedsheet where number cell useing conditonal formating will
change color if a less than condition takes place. What I need to know is how
do I once that conditional formating takes place (color change) do I send
this infor to a new spread sheet only if the condtion is met and to a thrid
spreedsheet within the same workbook that has a condition for dates i.e. like
expiration date.

My condition on the cell is that if the number entered is less than 2 (for
instance) the number in the cell will turn red and be bold. if this happen
(it turns red) I would like for it to then be sent to second spreadsheet as a
red bolded number two. I am trying to build a shopping list for my wife so as
she updates it (inventory list) with actual on hand numbers. If a number for
instance cans of soups fall to a present number like 2 ea then it will turn
red and send this information to a second spreadsheet to build an actual
shopping list. Then I would like to also set up the original list (inventory
list) so not only will i attached the conditionl formating toi turn red and
bold if it drops to this number, but also to date stamp the entry and
condition formate it to feed a thrid sheet for expiration dates for instasnce
if the original inventory entry is a given date then 180 days it will
automatically populate a third spreasheet to say throw it away. thank you for
you efforts