Here are the shortcut keys for working on the Pivot Table ...

To do this, use the drop-down menu on the left side of the formula box while inside the original IF statement. Helpful Hint: Another way to copy formats to other cells is to select the cells that have the conditional formats you want to copy and click the Format Painter button . ................
................