Info

Here is a fairly advanced example. We want to hide any error cells and then color negative numbers in red. The basic idea is to set up a conditional format that checks to see whether the cell contains an error or NA. If either is true, then we set the font color up to match the background. This first condition relies on the Formula Is syntax. The second condition is straightforward and relies on the Cell Value Is syntax. Figure 6.12 shows how this would be set up in the Excel user interface.

Figure 6.12

This cell contains a pair of conditional formats.The first is designed to hide any error value and uses the powerful Formula Is syntax.The second condition uses the more common Cell Value Is syntax.

Condition J.

iFctFUlalS v =0R(I5ERf

!iD9),15NA(D9))

0 0

Post a comment