I have a spreadsheet where the number valvue if it is less than a certain
number will change its color using conditional formating. What I would like
to know is HOW do I once the conditional formating is met send that number to
a different spreadsheet and then to a third spreadsheet if a condition for
date (greater than this date)

There is no direct way to check the conditional formatting, so you would
have to check the same condition that the conditional formatting is
checking.

--
Regards,
Tom Ogilvy

"James M" wrote in message
...
I have a spreadsheet where the number valvue if it is less than a certain
number will change its color using conditional formating. What I would
like
to know is HOW do I once the conditional formating is met send that number
to
a different spreadsheet and then to a third spreadsheet if a condition for
date (greater than this date)