View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
In-Thought In-Thought is offline
external usenet poster
 
Posts: 3
Default 3-Cell Conditional Formatting

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