Microsoft Excel Functions & Formulas

Use conditional formatting to control font

styles in a specific range

Conditional formatting can also be used to control font styles in a

specified range. Use cell E1 to enter letters like “i” for italic, “b”

for bold, and “s” for strikethrough. Use conditional formatting to

format the range as desired based on the input in cell E1.

4

To control font styles in a specified range:

1. In a worksheet, enter numbers in cells A1:D10 (or copy the

values in Figure 10-14), and select the range A1:D10.

2. On the Format menu, click Conditional Formatting.

3. Select Formula Is and type the following formula:

=$E$1="i".

4. Click Format.

5. On the Font tab, select Italic ...