3-Cell Conditional Formatting

[In-Thought]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Glenn]

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)