Simple Excel help..

[Syringer]

I have a spreadsheet with a bunch of cells that say n/a in them, intermixed with numbers. I want to highlight just the n/a's and change their font, how would I do this? Would there also be a way to just highlight the numbers?

 

[ggnl]

1. Highlight the cells you want the special formatting on.

2. Go to Format > Conditional Formatting

3. Go to the dropdown menu that says "Cell Value Is". Change it to "Formula Is".

4. In the formula bar type =INSA("first cell") where "first cell is the first cell of the array of cells you currently have highlighted. Make sure you take off all absolute references (the dollar signs).

5. Hit the Format button under the formula bar and do the format however you want.

 

[Syringer]

Ahh, that's so simple, can't believe I didn't see that feature. Thanks!