Forum Home
Press F1
Thread ID: 6162	2000-10-18 21:58:00	Excel	Guest (0)	Press F1

Post ID	Timestamp	Content	User
6764	2000-10-18 21:58:00	I have 2 queries; 1. how can I make column A stay on the screen no matter how far right I scroll? & 2. Is there a formula I can use to automatically change a number to a negative by changing it's color? (I want to be able to have b2+c2+d2+e2+f2+g2= then if I change the color of d2 to red I want the number in that cell to become -. So the 2 in that cell becomes -2.) Thanks.	Guest (0)
1