Why bother with =IF(...,1,0) ?
What's wrong with =J2="" ?
--
David Biddulph

"FSt1" wrote in message
...
hi
may need more detail but.....
formual is.....=IF(J2="",1,0).......format = pukey green. (choose your
own.)

post back if that don't work....with more detail.

Regards
FSt1

"Jman" wrote:

I need a formula in conditional formating.
I am CF'ing column M.

If column J contains blank cells.... format .