Hi,
ever since Office 2007 I came to hate the new layout for the conditional formatting... I know have to advise excel a formula affecting the whole sheet (range A2:L5000) to check if cells in column L DO NOT PARTLY contain "@" or "." characters, and then highlight them red. Blank cells should not be affected by this and remain white.
I tried working around with IF statements, but excel seems to want a TRUE/FALSE formula response...
Any help please?
Thanks,
A2k
Bookmarks