J Jman Sep 17, 2008 #1 I need a formula in conditional formating. I am CF'ing column M. If column J contains blank cells.... format .
I need a formula in conditional formating. I am CF'ing column M. If column J contains blank cells.... format .
F FSt1 Sep 17, 2008 #3 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
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
J Jman Sep 17, 2008 #4 FSt1 said: 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. Click to expand... This worked perfectly.. Thanks.
FSt1 said: 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. Click to expand... This worked perfectly.. Thanks.
J Jman Sep 18, 2008 #6 Yeah, this works too.. .Good to know Thanks. David Biddulph said: Why bother with =IF(...,1,0) ? What's wrong with =J2="" ? Click to expand...
Yeah, this works too.. .Good to know Thanks. David Biddulph said: Why bother with =IF(...,1,0) ? What's wrong with =J2="" ? Click to expand...
