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.
MS Excel - Change text with IF
Name: mcamax Date: March 2, 2006 at 10:26:49 Pacific OS: Windows 2000 Pro CPU/Ram: PIII/512MB Product: HP Vectra
Comment:
I know how to use an IF statement to change the value of a cell in MS Excel (Office XP). But can the color of the text be changed also? Or the background fill?
Name: Bryco Date: March 2, 2006 at 15:10:14 Pacific
Reply:
Yes using Conditional format via Format, Conditional Formatting. You can incorporate an IF statement if needed.
Bryan
0
Response Number 2
Name: mcamax Date: March 2, 2006 at 15:52:54 Pacific
Reply:
Thanks, Bryan. Works great! I used an IF statement to determine the value of the cell, then conditional formatting to set the background color for two conditions.
Summary: Hello, Anybody know how to change the the data from rows into columns or say in the other word is to rotate a table in MS Excel? Thank you very much. ...
Summary: While working with MS Excel I was trying to figure a way to automatically open and print a document at a specific time. For example, every Monday morning at 7am, I should be able to walk to the printe...
Summary: i have 2 users that access the same excel spreadsheet. user 1 will access it make changes save it and email it to the 2nd user and vice versa. however it recently started to change the formatting of h...
0 
