Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel - reformat cells on the fly
Name: MrMango56 Date: February 27, 2004 at 07:23:19 Pacific OS: Windows XP CPU/Ram: Athlon 1.8 / 512MB
Comment:
I need to know if there is a way to do data checking on a cell as it is entered. What I need is for the cell to automatically change itself to a negative value if a positive one is entered. Is there any way for a cell to modify itself?
Name: ricehead Date: February 27, 2004 at 07:30:23 Pacific
Reply:
Not that I know of. But, one easy way to do this is make a separate column that refers to the column where the data is entered. =sum(data cell*-1) then just fill down for all the cells you want to calculate in this manner
That way, you will have another column that represents the negative value of whatever data is entered (assuming the date is all positive)
0
Response Number 2
Name: MrMango56 Date: February 27, 2004 at 07:49:33 Pacific
Reply:
Thanks for the response.
Actually, I can't be sure that the data in the first column will be positive, so I used the formula =-(ABS(cell)), which seems to work. I was just wondering if there was a way to do it without using an extra column.
MrMango
0
Response Number 3
Name: ricehead Date: February 27, 2004 at 08:01:30 Pacific
Reply:
yeah, forgot about absolute value command...
dunno about doing it in same cell, maybe someone else will chime in to help
0
Response Number 4
Name: J A Dean Date: February 27, 2004 at 10:19:47 Pacific
Reply:
You could use the data validation option:
Data>>Validation>>Settings and specify that the data is less than zero.
HTH
"In the land of the blind the one eyed man is king"
0
Response Number 5
Name: bill_ma Date: March 2, 2004 at 02:53:41 Pacific
Summary: I was wondering if it was possible to change a cells value depending on the date set on your computer. If not is there any other software that you know of that can do this aswell as the basic stuff ex...
Summary: Hi I have a question regarding highlighting Excel cells. I am designing a quiz whereby I have set the conditional formatting to reveal the contents of another cell once the correct answer has been inp...
Summary: No. But you can create lists that it can remember. Tools, Options, Custom Lists. For example: It has a couple already such as Mon, Tue, Wed, Thu... or Jan, Feb, Mar and so on. If you type "Mon" in a c...
0 
