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)