"oldjay" wrote:
When I use the function arguments it says
if(ID606="Y" is true when ID606 is blank .WHY?
=IF(ID606="Y",1,2)

The only thing that comes to mind is that you have format or conditional
format options that are selecting the same color for foreground and
background.