Can't be done with formatting, conditional or otherwise. Formatting just
controls how things appear.
What you could do on the other sheet is set up an IF() statement testing the
value(s) of the cells on the first sheet, and if they meet the criteria, echo
them there on that other sheet.
Lets say you want to 'move' (not correct, as we are going to echo it) the
value in Sheet1!A1 if it is between 10 and 25.
Over on another sheet you could have a formula like this:
=IF(AND(Sheet1!A1>=10,Sheet1!A1<=25),Sheet1!A1,"")
that would display the contents of Sheet1!A1 on this sheet when it is
between 10 and 25 (inclusive), and not show anything when it isn't.
