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

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

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



Conditional formatting (correcting the cell references as needed):

=ISNA($A$1)*ISNA($B$1)*ISNA($C$1)