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 if statement
Name: dm1 Date: December 9, 2008 at 14:09:02 Pacific OS: xp CPU/Ram: 1gb Product: Dell latitude / 5500
Comment:
Would like a product listing in a cell(from a drop down box) to turn red when a x is placed in different cell. The x(which is red) identities the material as a hazardous material and want the description to be red also
Name: Bryco Date: December 10, 2008 at 08:15:39 Pacific
Reply:
Use Conditional Formatting.
Bryan
0
Response Number 2
Name: jackgopher Date: January 4, 2009 at 03:38:22 Pacific
Reply:
Yeah, what you need is conditional formatting. With it you can highlight cells and color them, depending on their values. The if statement won't format your data, but only result in some text or some calculation appearing based upon your data.
Summary: Hi, I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ten. Basically, I need a formula that says IF the ...
Summary: Could I please obtain some help creating an Excel IF statement, considering the following parameters: - There is a date in cell A1 - The statement will appear in A2 - If the date in A1 is more than 30...
Summary: What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional format in excel ...
0 
