2013/10/21
To enter most fractions, type 0. Then, press the spacebar and type the fraction, including the slash. Excel will display the value as a fraction and store the decimal value.
To use Conditional Formatting:
- Select a range of values.
- On the Home tab, in the Styles group, click Conditional Formatting.
- Select a conditional format from an available gallery.
Tip: Use the More Rules option at the bottom of a gallery to further customize your conditional formatting.
Submitted by Jan Huber, Learning Services Manager, Faegre Baker Daniels, LLP