1.Select the column. say A. If the first cell is A1
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=ISNA(A1)
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"In-Thought" wrote:

There are three consecutive cells in a row that are pulling data from other
three worksheets using vlookup. If these cells all contain "#n/a" they should
format to another color to help bring attention to the results.

Tried several statements but haven't cracked it. Could you help me please