excel if statement

Dell latitude / 5500
December 9, 2008 at 14:09:02
Specs: xp, 1gb
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

See More: excel if statement

Report •

December 10, 2008 at 08:15:39
Use Conditional Formatting.


Report •

January 4, 2009 at 03:38:22
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.

Report •

Related Solutions

Ask Question