Thread: conditional format cells with formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default conditional format cells with formula
You could try adding Condition 2 with a suitable format to mask the #N/A

Assuming B2 is the top left active cell selected within your conditional
formatting range, Formula is: =ISNA(B2)
Format the font color same as fill color
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amos" wrote:
I have a summary worksheet that references another with a vlookup table. The
conditional formatting works if a value is entered on the lookup sheet.
However, if the cell isn't filled with a number on the summary sheet I get
the #N/A. That is what I'm trying to hide this with text color. PLEASE help?
Reply With QuoteReply With Quote