3-Cell Conditional Formatting

  • Thread starter Thread starter In-Thought
  • Start date Start date
I

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
 
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
 
In-Thought said:
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
Click to expand...

Conditional formatting (correcting the cell references as needed):

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