1. I have a hiden worksheet that I would like to sort. So far, I am only
able to get the macro to work if I make the worksheet active in order to
sort. I need to keep the sheet hidden. Is there a way to sort a hidden
worksheet?

2. In my spreadsheet I have certain rows that are colored in background RED.
I would like to use the IF in a cell to say something like "IF A1=background
in RED, A1+2, A1*2". Is it possible?

Thanks
Kim