Hi,

I've developed a formula that recognises is a cell is lower case:

=(NOT(EXACT(UPPER(J2),J2)))=AND(NOT(ISBLANK(J2)))

But I want this forumla to work with J2:N2, so meaning if one of these 5 cells has lower case letter in it, it will pick it up. I've tried just putting J2:N2 where I have J2 but this doesn't work. I've probably gone round the houses to get what I want but any help would be greatly appreciated.

Thanks.